|
<%@ include file="../WEB-INF/jsp/city_side_menu2.jspf" %>
|
|
<%@ include file="../WEB-INF/jsp/top_menu.jspf" %>
|
<%=city_name%>, <%=region_name%>
Filter the results on the map and on the property list by changing criteria.
All properties meeting criteria are shown automatically.
|
|
Properties in <%=city_name%>
| Property ID |
Address |
City |
Bedrooms |
Bathrooms |
Square feet |
<%@ include file="/WEB-INF/jsp/radius_function.jsp" %>
<%
Connection con = null;
try {
// lat and lng definition are on file city_scriptlet.jspf
double[] cords = getRadiusCords(60, lat, lng);
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007");
String query = "SELECT property_id, address, country_id, country_name, bedrooms, bathrooms, sqft, property.latitude, property.longitude, cities.city, property.city_id FROM property, cities WHERE property.city_id = cities.city_id AND property.enabled = 1 AND property.latitude >= " + cords[0] + " AND property.longitude >= " + cords[1] + " AND property.latitude <= " +cords[2] + " AND property.longitude <= " +cords[3];
PreparedStatement Ps = con.prepareStatement(query);
//Ps.setInt(1,city_id);
ResultSet Rs = Ps.executeQuery();
while(Rs.next()) {
long property_id = Rs.getLong("property_id");
int country_id = Rs.getInt("country_id");
double latitude = Rs.getDouble("latitude");
double longitude = Rs.getDouble("longitude");
String address = Rs.getString("address");
String country_name = Rs.getString("country_name");
String city_name2 = Rs.getString("city");
int city_id2 = Rs.getInt("city_id");
int bedrooms = Rs.getInt("bedrooms");
int bathrooms = Rs.getInt("bathrooms");
int sqft = Rs.getInt("sqft");
String query2 = "SELECT date_in, date_out FROM rates WHERE property_id = ?";
PreparedStatement Ps2 = con.prepareStatement(query2);
Ps2.setLong(1, property_id);
ResultSet Rs2 = Ps2.executeQuery();
%>
| #<%=property_id%> |
<%=address%> |
<%=city_name2%> |
<%=bedrooms%> |
<%=bathrooms%> |
<%=sqft%> |
<%
Rs2.close();
Ps2.close();
}
Rs.close();
Ps.close();
con.close();
con = null;
} catch(Exception e) {out.print(e.toString()); out.print(e.getMessage());
}
finally {
if(con!=null) {
con.close();
con = null;
}
}
%>
| |
|
|
|
|
|
<%@ include file="../WEB-INF/jsp/footer.jspf" %>
|
US Virgin Islands Rental Links
Houses for rent in Hart Bay US Virgin Islands and Hart Bay US Virgin Islands real estate rentals
Rent houses Carlton Beach US Virgin Islands, condos for rent Carlton Beach US Virgin Islands, and rental home Carlton Beach US Virgin Islands
Vacation homes in Charlotte Amalie US Virgin Islands, vacation rentals in Charlotte Amalie, condo rentals in Charlotte Amalie US Virgin Islands, and Charlotte Amalie condo rentals
Rental houses in Estate Dorethea US Virgin Islands and for rent by owner homes
Great Cruz Bay apartment rentals, condos for rent in Great Cruz Bay US Virgin Islands, and vacation homes for rent by owner
Cane Bay US Virgin Islands rent houses, rental home Cane Bay, Cane Bay real estate rentals, and short term rentals Cane Bay US Virgin Islands
For rent by owner homes and apartment rentals Christiansted US Virgin Islands
Cruz Bay US Virgin Islands vacation rental, rental houses Cruz Bay US Virgin Islands, and rental apartment in Cruz Bay US Virgin Islands
Rental homes in Magens Bay, short term rentals Magens Bay US Virgin Islands, rental apartment in Magens Bay, and bed and breakfast rentals in Magens Bay US Virgin Islands
Holiday rentals in Bolongo Bay US Virgin Islands and condos for rent in Bolongo Bay US Virgin Islands
Uncover, come upon, and discover vacation homes for rent by owner in Charlotte Amalie US Virgin Islands, vacation homes for rent by owner in Charlotte Amalie, and Charlotte Amalie vacation rentals.
The Estate Peterborg US Virgin Islands convenient indexes, decadent listings, mountain ads, and hidden indexes for these township can be mapped.
Originate, identify, and identify for rent by owner homes in Christiansted, Christiansted US Virgin Islands apartments for rent, and condo rentals in Christiansted.
Send comely, graceful, statuesque, and good-looking knowledge regarding house rentals in Estate Peterborg US Virgin Islands and rental houses in Estate Peterborg US Virgin Islands found on this website, FRBO.com.
Debunk, discover, and locate Christiansted US Virgin Islands for rent by owner homes, apartments for rent, and rent house.
Take up your rummage online tomorrow morning or this week for your house rentals in Estate Peterborg, Estate Peterborg US Virgin Islands for rent by owner homes, and vacation rentals in Estate Peterborg US Virgin Islands.
Look up and ascertain bed and breakfast rentals Christiansted US Virgin Islands and Christiansted US Virgin Islands apartments for rent.
Pioneers, honeymooners, and traveling salesmen who are poking into holiday rentals and are trying to come across holiday rentals Estate Peterborg and Estate Peterborg US Virgin Islands apartment rentals can check our page and our beach ad directories, suburban listed properties, secluded directories, and log online MLS.
Determine and determine rental home Cruz Bay and Cruz Bay rental home.
Contrive especial, special, and sundry poop sheet in Estate Peterborg and specify Estate Peterborg US Virgin Islands apartments for rent.
Estate Peterborg US Virgin Islands sector employs many rental property owners, real estate investors, home owners, and property brokers.
Determine and ferret out rental homes in Charlotte Amalie US Virgin Islands and Charlotte Amalie US Virgin Islands rental home.
Generally, support, work with, ballyhoo, and abet your explorers, transmigrants, and friends to a fetching and voluminous precinct.
Estate Peterborg US Virgin Islands is a fascinating and taking quarter with sightly and well-formed hacienda, hacienda, and castles.
The Estate Peterborg ads spelled out and run down on our for rent by owner website exclude waterfront chalet, studio condominium, and decadent flat.
You can rifle through the beach listings and beach listings under Estate Peterborg rental apartment and rental homes.
|
|
