| |
<%
''Response.write Request.Form
rid = 26
elno = "No"
aviablename = "Available"
myDSN=Session ("connectionstring")
set conn = server.CreateObject("ADODB.Connection")
conn.Open myDSN
mySQL = "select property.id, property.property_image, property.areaid, property.bedroomid, property.bathroomid, property.propertytypeid, property.property_price, property.short_descrip, property.realtorid, property.psquarefeet, property.currency_price from property, propertyrealtor where (propertyrealtor.propertyidrp = property.id and propertyrealtor.realtoridrp = '"& rid &"' and property.exclusive_listing = '"& elno &"' and property.status = '"& aviablename &"')"
set rstemp2 = conn.Execute(mySQL2)
If rstemp2.EOF then
Response.Write "
Sorry, the Property you entered does not exist." & " "
Response.Write " Please select another property." & " "
Response.Write " "
rstemp2.Close
set rstemp2 = nothing
else
set id = rstemp2("id")
set realtoriddisplay = rstemp2("realtorid")
set propertytypeiddisplay = rstemp2("propertytypeid")
set shortdescripdisplay = rstemp2("short_descrip")
set longdescripdisplay = rstemp2("long_descrip")
set streetadd1display = rstemp2("address1")
set streetadd2display = rstemp2("address2")
set areaiddisplay = rstemp2("areaid")
set locationiddisplay = rstemp2("locationid")
set countryiddisplay = rstemp2("countryid")
set bathroomiddisplay = rstemp2("bathroomid")
set bedroomiddisplay = rstemp2("bedroomid")
set psquarefeetdisplay = rstemp2("psquarefeet")
set lsquarefeetdisplay = rstemp2("lsquarefeet")
set propertyimagedisplay = rstemp2("property_image")
set roompicdisplay = rstemp2("roompic")
set webpagedisplay = rstemp2("web_page")
set priceiddisplay = rstemp2("priceid")
set pvaluedisplay = rstemp2("property_value")
set currencyvaluedisplay = rstemp2("currency_value")
set pricedisplay = rstemp2("property_price")
set currencypricedisplay = rstemp2("currency_price")
set exclusivelistingdisplay = rstemp2("exclusive_listing")
set floorplandisplay = rstemp2("floor_plan")
set statusdisplay = rstemp2("status")
%>
 |
Location of Property |
<%
'//////////////////////
'SQL statement to select all the Items in the Items table
'to be displayed in the drop down box for the user to select
mySQL442 = "select * from location where id = '"& locationiddisplay &"'"
'//////////////////////
set rstemp442 = conn.Execute(mySQL442)
set catnum442 = rstemp442("id")
set catname442 = rstemp442("name")
set catnamearea442 = rstemp442("areaid")
do until rstemp442.EOF
%>
<%
'//////////////////////
'SQL statement to select all the Items in the Items table
'to be displayed in the drop down box for the user to select
mySQL442442 = "select * from area where id = '"& catnamearea442 &"'"
'//////////////////////
set rstemp442442 = conn.Execute(mySQL442442)
set catnum442442 = rstemp442442("id")
set catname442442 = rstemp442442("name")
do until rstemp442442.EOF
%>
<% Response.Write catname442442 & " - "%>
<%
rstemp442442.MoveNext
loop
%>
<% Response.Write catname442 %>
<%
rstemp442.MoveNext
loop
rstemp442.Close
set rstemp442 = nothing
%>
|
|
Sq. Feet |
<%Response.Write psquarefeetdisplay %> |
| No.
of Bed Rooms |
<%
mySQL5 = "select * from bedroom where id = '"& bedroomiddisplay &"'"
set rstemp5 = conn.Execute(mySQL5)
set bedroomname = rstemp5("name")
Response.Write bedroomname
rstemp5.Close
set rstemp5 = nothing
%> |
| No.
of Bath Rooms |
<%
mySQL6 = "select * from bathroom where id = '"& bathroomiddisplay &"'"
set rstemp6 = conn.Execute(mySQL6)
set bathroomname = rstemp6("name")
Response.Write bathroomname
rstemp6.Close
set rstemp6 = nothing
%> |
| Price |
<%
mySQL2223 = "select * from rent where property_id = '"& id &"'"
set rstemp2223 = conn.Execute(mySQL2223)
set propertyiddisplay = rstemp2223("property_id")
set rentvaluedisplay = rstemp2223("rentvalue")
set rentperdisplay = rstemp2223("rentper")
set rentcurrencydisplay = rstemp2223("rentcurrency")
set avaiabledatedisplay = rstemp2223("avaiabledate")
set renttobuydisplay = rstemp2223("renttobuy")
set longtermdisplay = rstemp2223("longterm")
set shorttermdisplay = rstemp2223("shortterm")
set petsdisplay = rstemp2223("pets")
set furnituredisplay = rstemp2223("furniture")
set utilitiesdisplay = rstemp2223("utilities")
set childrendisplay = rstemp2223("children")
do until rstemp2223.EOF
%>Rent Per <%Response.Write rentperdisplay %>: <%
Response.Write FormatCurrency(rentvaluedisplay,2) & " " & rentcurrencydisplay
%>
<%
rstemp2223.MoveNext
loop
rstemp2223.Close
set rstemp2223 = nothing
%>
|
| Details |
<% Response.Write shortdescripdisplay %> |
<% end if %>
|
Location of Property |
Mohammed
Ville |
| Land
Area |
5,000 sq ft (Approx) |
| Floor
Area |
2000 sq ft (Approx.) |
| No.
of B/Room |
Two
- three |
| No.
of Bath |
2
tb |
| Price |
$5000
furnished |
| Details |
Airconditioned
Bedrooms, property in good condition, has a library living area
dining and kitchen, TV room / third bedroom. Washing area, two car
covered garage, w/ fruit trees gazebo and fenced. A very respectable
area in the heart of San Juan / El Soccorro. |
|
Location of Property |
St.
Augustine |
| Land
Area |
5000
Sq Ft |
| Floor
Area |
Approx.
2500 sq ft |
| No.
of B/Room |
Three
3 Bedroom upstairs & two 2 bedroom dowstairs |
| No.
of Bath |
1 T/B for each apartment |
| Price |
$3500.
(Top Three Bedroom) |
| Details |
This
property is located close to UWI and Hugh Wooding Law school. Walking
distance from main road and bus route. It is perfect as both residential
and commercial due to its location. There is a great demand for
such in this area and this property holds great promise for the
investor. |
|
Location of Property |
Tunapuna |
| Land
Area |
6,000 sq ft (Approx) |
| Floor
Area |
4000 sq ft (Approx.) |
| No.
of B/Room |
Fourteen
one room units and one two bedroom Unit |
| No.
of Bath |
15
tb |
| Price |
TT
$1000 per room furnished, TT $900 unfurnished,
Two bedroom $2000 furnished $1800 unfurnished
Includes Electricity. |
| Details |
Very
close to the bus route and the Eastern Main Road. Ideal for students
or single working people. Washing facilities are available. Area
is private, safe and secure. All appliances are new building newly
refurbished. |
|
Location of Property |
Curepe |
| Land
Area |
8000 sq ft |
| Floor
Area |
4000 sq ft (Approx) |
| No.
of B/Room |
two
three Bedrooms (upstairs), four two bedrooms (downstairs) |
| No.
of Bath |
8
t/b |
| Price |
TT
$1200. furnished per person per room TT $1000. unfurnished per person
per room |
| Details |
Close
to the university this apartment building holds great promise for
the investor. With a growing demand for rooms within the area, tenanting
will not be a problem. Near to the bus route, Eastern Main Road
and supermarkets, this location is ideal for student accomodation.
Potential rental income will subsidise the mortgage. |
|
Location of Property |
Westmoorings |
| Land
Area |
End Unit |
| Floor
Area |
1400 sq ft (Approx.) |
| No.
of B/Room |
Three
(3) |
| No.
of Bath |
1.5
tb |
| Price |
$1,800
USD |
| Details |
Top
residential area close to Port of Spain, Minimal traffic into the
capital. All bedrooms air-conditioned, entertainment area, completely
fenced, electronic gate, parking for two cars. Living area w/ 2
Queen sized couches, dining area w/ table for six, kitchen w/ gas
stove, microwave, fridge, sitting room w/ tv,stero , vcr, Laundry
room w/ washer and dryer. This Is rented fully furnished. |
|
Location of Property |
Goodwood
Park |
| Land
Area |
10,000 sq ft (Approx) |
| Floor
Area |
4000 sq ft (Approx.) |
| No.
of B/Room |
Three
(3) |
| No.
of Bath |
2
tb |
| Price |
$2,800
USD (Neg) TENANTED |
| Details |
Top
residential area with a great view of the Gulf of Paria, close to
Port of Spain, Minimal traffic into the capital. All bedrooms air-conditioned,
with maid's quarters, entertainment area, Jacuzzi, electronic gate,
parking for four cars. |
|
Location of Property |
Auzonville
Heights, St Augustine. |
| Land
Area |
Common
Landscaped Grounds |
| Floor
Area |
2
storey 1800 sqft |
| No.
of B/Room |
three
(3) |
| No.
of Bath |
2
1/2 baths |
| Price |
$5000
Furnished . TENANTED |
| Details |
Town
Houses, 24 hr Security, Landscaped Grounds, Parking facilities,Covered
Car Port for 1 car w/ remote controlled garage door, End unit. Maintenance
fee $200/mth. Close to University, schools, restaurants and shopping
areas. |
|
Location of Property |
Auzonville Heights, St Augustine. |
| Land
Area |
Common
Landscaped Grounds |
| Floor
Area |
Trilevel
1800 sqft |
| No.
of B/Room |
three
(3) |
| No.
of Bath |
2
1/2 baths |
| Price |
$4000
(Unfurnished) - $5000 (Furnished) TENANTED |
| Details |
Town
Houses, 3 Units Available, 24 hr Security, Landscaped Grounds, Parking
facilities,Covered Car Port for 1 car, Partially Air Conditioned.
Close to University, schools, restaurants and shopping areas. |
|
