Loan Calculator
 
SELECT * FROM tblnews ORDER BY NewsDate DESC

#DateFormat(NewsDate, "dd.mm.yy")#

#NewsTitle#

#Left(REReplace(Description,'<[^>]*>','','all'), 100)#... read more
SELECT PropertyName, PropertyID, SalesPrice, RentalPrice, Status, Photo1, Location, HouseType, CASE WHEN DateUpdated > DateEntered THEN DateUpdated ELSE DateEntered END AS LatestDate FROM tblproperties,tbllocations,tblhousetypes WHERE tblproperties.LocationID = tbllocations.LocationID AND tblproperties.HouseTypeID = tblhousetypes.HouseTypeID AND IsSpecial = 1 AND IsActive = 1 ORDER BY latestdate DESC SELECT PropertyName, PropertyID, SalesPrice, RentalPrice, Status, Photo1, Location, HouseType, CASE WHEN DateUpdated > DateEntered THEN DateUpdated ELSE DateEntered END AS LatestDate FROM tblproperties,tbllocations,tblhousetypes WHERE tblproperties.LocationID = tbllocations.LocationID AND tblproperties.HouseTypeID = tblhousetypes.HouseTypeID AND IsFeature = 1 AND IsActive = 1 ORDER BY latestdate DESC

Dream House Properties website is the easy way to find all sorts of properties located in Penang. Every property featured on the site is listed by a Licensed Real Estate Agent. Our real estate consultancy firm is located in Penang and provide wide ranging property services. Find homes for sale, lifestyle property, auction property, businesses for sale or lease, commercial properties for sale or lease as well as rental properties throughout Penang. This is the only place for your place.

#PropertyName#

#Location#
#HouseType#
Sale: RM #left(SalesPrice, len(SalesPrice)-3)#kRM #NumberFormat(SalesPrice)#RM #SalesPrice#

Rent: RM #left(RentalPrice, len(RentalPrice)-3)#kRM #NumberFormat(RentalPrice)#RM #RentalPrice#
More...  

#PropertyName#

#Location#
#HouseType#
Sale: RM #left(SalesPrice, len(SalesPrice)-3)#kRM #NumberFormat(SalesPrice)#RM #SalesPrice#

Rent: RM #left(RentalPrice, len(RentalPrice)-3)#kRM #NumberFormat(RentalPrice)#RM #RentalPrice#
More...