set conn = Server.CreateObject("ADODB.Connection") set rs = server.CreateObject("ADODB.Recordset") conn.open "DSN=" & application("DBDSN") & ";UID=" & application("DBUsername") & ";PWD=" & application("DBPassword") & ";" if err.number <> 0 then err.Description end if Q = "SELECT models.id as ModelID, models.type, models.model_name, models.bedrooms, models.area, models.renderinga, communities.name, communities.id AS COMMID, min(model_prices_comm.price) as PRICE" Q = Q & " FROM (models INNER JOIN model_prices_comm ON models.id = model_prices_comm.model_id) INNER JOIN communities ON model_prices_comm.comm_id = communities.id" Q = Q & " WHERE 0 = 0 AND communities.name='Village Gardens'" Q = Q & " GROUP BY models.type, models.id, model_name, bedrooms, area, communities.name, communities.id, renderinga ORDER BY type ASC, PRICE ASC, model_name ASC" rs.Open Q, conn previousModelType = "" modelCount = 0 do while not rs.eof strModelID = rs("ModelID") strModelType = rs("type") strModelName = rs("model_name") strModelCommunity = rs("name") strModelBed = rs("bedrooms") strModelArea = rs("area") strModelPrice = rs("PRICE") strModelRendering = rs("renderinga") if not isnumeric(strModelPrice) OR strModelPrice = "0" then strFinalPrice = "N/A" else strFinalPrice = formatcurrency(strModelPrice,0) end if strCommID = rs("COMMID") if strModelType = previousModelType then previousModelType = strModelType strModelType = "" else if modelCount > 0 then strTableData = strTableData & " " end if previousModelType = strModelType end if strTableData = strTableData & ""& strModelType &"" & strModelName & "" & strModelBed & "" & formatnumber(strModelArea,0) & "" & strFinalPrice & "" modelCount = modelCount + 1 rs.MoveNext loop rs.Close conn.close %> Valecraft | Village Gardens
MainAbout UsCommunitiesSearchServicegalleryTestimonialsContact UsScrapbook







Located 35 minutes east of Ottawa in the lovely community of Embrun you will find Village Gardens, a new neighbourhood.

With a population of 5,000, Embrun offers country living with Big City amenities. A rich, bilingual atmosphere exists in this 100-year-old community. Embrun is sure to make a great impression the minute you walk down the street and meet the charming residents.

See you in Embrun.

Models Available in Village Gardens
House Type Model Bedrooms Approx. Sq. Ft. $ From



Village Gardens Sales Centre Closed

Tel: (613) 824-0675



click to enlarge
VALECRAFT HOMES LTD.
MAIN OFFICE		 1455 Youville Drive, Suite 216
Orleans ON  K1C 6Z7		 T (613) 837-1104
F (613) 837-5901		 info@valecraft.com

RENDERINGS ARE ARTIST CONCEPTS. PRICES, TERMS, AVAILABILITY AND SPECIFICATIONS ARE SUBJECT TO CHANGE WITHOUT NOTICE. E. & O. E.