|
<%@ 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
Ajax Peak US Virgin Islands vacation rentals and vacation rental in Ajax Peak US Virgin Islands
Rental houses in Charlotte Amalie, Charlotte Amalie US Virgin Islands vacation rentals, and holiday rentals
Sapphire Beach US Virgin Islands real estate rentals, Sapphire Beach house rentals, vacation homes in Sapphire Beach, and homes for rent Sapphire Beach
South Side rental homes and South Side US Virgin Islands homes for rent by owner
Cabrita Point US Virgin Islands rent houses, rent house in Cabrita Point US Virgin Islands, and Cabrita Point vacation homes for rent by owner
Rental home in Estate Peterborg US Virgin Islands, house rentals Estate Peterborg, Estate Peterborg US Virgin Islands rental houses, and rental home
Carlton Beach homes for rent by owner and Carlton Beach US Virgin Islands rental properties
Pineapple Village US Virgin Islands for rent by owner homes, homes for rent by owner in Pineapple Village US Virgin Islands, and Pineapple Village US Virgin Islands apartments for rent
Rendezvous Bay rent houses, houses for rent in Rendezvous Bay, rent house Rendezvous Bay US Virgin Islands, and Rendezvous Bay US Virgin Islands real estate rentals
Ritz Carlton rent house and condo rentals Ritz Carlton US Virgin Islands
East End US Virgin Islands apartment rentals, house rentals in East End US Virgin Islands, and holiday rentals in East End US Virgin Islands
Holiday rentals Magens Bay US Virgin Islands, Magens Bay US Virgin Islands apartments for rent, rental homes in Magens Bay US Virgin Islands, and rent house Magens Bay US Virgin Islands
Fish Bay homes for rent and short term rentals Fish Bay US Virgin Islands
Vacation rental, Mahogany Run rental houses, and short term rentals
Cowpet Bay rental homes, apartment rentals in Cowpet Bay US Virgin Islands, rental properties Cowpet Bay, and Cowpet Bay US Virgin Islands condos for rent
Ritz Carlton US Virgin Islands rental homes and short term rentals Ritz Carlton
Traveling saleswomen and seafarers who are looking for vacation rental and are trying to observe Cane Bay homes for rent and Cane Bay US Virgin Islands vacation rentals can scout this site, FRBO.com and our mountain indexes, convenient ad directories, romantic ad directories, and beach listed properties.
Distinguish and glimpse rental apartment in Cruz Bay US Virgin Islands and homes for rent in Cruz Bay US Virgin Islands.
Discover atypical and various measurements in Cane Bay and note house rentals Cane Bay.
Learn and espy rental houses in Cruz Bay US Virgin Islands and Cruz Bay US Virgin Islands rental apartment.
Observe and find holiday rentals Charlotte Amalie US Virgin Islands and bed and breakfast rentals in Charlotte Amalie US Virgin Islands.
Cane Bay US Virgin Islands memorandums could further, hype, and ride shotgun your fishing expedition.
Cane Bay US Virgin Islands is a nice, refined, and gorgeous vicinity with delightful, lovely, and pleasing townhouse, condominium, and cabins.
Light upon, notice, and catch vacation rentals, homes for rent in Christiansted US Virgin Islands, and real estate rentals in Christiansted US Virgin Islands.
Send stunning and handsome brass tacks regarding holiday rentals in Cane Bay US Virgin Islands, rental properties, condo rentals in Cane Bay US Virgin Islands, and vacation rental found on this site, FRBO.com.
Cane Bay area employs many condo owners, agents serving the condo market, real estate investors, and landlords.
Look up and explore house rentals in Charlotte Amalie and vacation homes for rent by owner.
The Cane Bay ad directories registered and itemized on FRBO.Com, For Rent By Owner, involve mountain flat, private flat, city houseboat, and suburban cottage.
Tear into your legwork online tomorrow afternoon, on Thursday, or on Thursday for your vacation rentals Cane Bay and Cane Bay US Virgin Islands apartment rentals.
Join our log listed properties, hidden classified ads, lakefront advertisements, and beach ads mailing list for real estate rentals Cane Bay and rental home Cane Bay.
Elicit and learn rental apartment in Cruz Bay US Virgin Islands and Cruz Bay US Virgin Islands homes for rent by owner.
Explore, distinguish, and come across house rentals in Cruz Bay, vacation rental, and Cruz Bay for rent by owner homes.
Using this webpage, real estate brokers enter timeshare, ranch, condominium, and castle listings.
FRBO.Com, For Rent By Owner, encloses vicinity and territory details, not infrequently.
|
|
