|
<%@ 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
Estate Peterborg US Virgin Islands home rentals and rental homes Estate Peterborg
For rent by owner homes Caret Bay, Caret Bay US Virgin Islands houses for rent, and homes for rent by owner in Caret Bay US Virgin Islands
Bed and breakfast rentals in Estate Dorethea US Virgin Islands, rental houses Estate Dorethea, rental homes in Estate Dorethea US Virgin Islands, and rental home in Estate Dorethea US Virgin Islands
Frenchman s Bay houses for rent and home rentals in Frenchman s Bay US Virgin Islands
Short term rentals in Bordeaux Mountain US Virgin Islands, Bordeaux Mountain US Virgin Islands rental apartment, and real estate rentals in Bordeaux Mountain
Water Island US Virgin Islands apartment rentals, rental apartment Water Island, rental homes in Water Island US Virgin Islands, and Water Island US Virgin Islands rent house
House rentals in North Shore US Virgin Islands and bed and breakfast rentals North Shore US Virgin Islands
Holiday rentals Cane Bay, rental apartment in Cane Bay US Virgin Islands, and Cane Bay US Virgin Islands rent house
Coral Bay US Virgin Islands rent houses, vacation homes for rent by owner in Coral Bay, Coral Bay US Virgin Islands vacation homes for rent by owner, and apartment rentals in Coral Bay US Virgin Islands
Rent house Bordeaux Mountain and Bordeaux Mountain bed and breakfast rentals
Apartments for rent in Pelican Beach US Virgin Islands, Pelican Beach US Virgin Islands vacation homes, and Pelican Beach US Virgin Islands real estate rentals
Short term rentals in Cane Bay, Cane Bay rental houses, rent house in Cane Bay US Virgin Islands, and bed and breakfast rentals Cane Bay
Real estate rentals Bolongo Bay and Bolongo Bay US Virgin Islands holiday rentals
Bordeaux Mountain US Virgin Islands vacation homes for rent by owner, rent houses Bordeaux Mountain, and vacation rentals in Bordeaux Mountain
Mahogany Run rental houses, vacation homes in Mahogany Run, rental properties Mahogany Run, and Mahogany Run US Virgin Islands condos for rent
Christiansted US Virgin Islands homes for rent by owner and condo rentals in Christiansted
Vacation rental in Estate Dorethea, rental homes Estate Dorethea, and Estate Dorethea US Virgin Islands vacation homes for rent by owner
Navigators, venturers, and brides frisk and look over our for rent by owner website and look up ski in/out vacation home and oceanfront flat.
Move, find out, and glimpse Charlotte Amalie short term rentals, Charlotte Amalie US Virgin Islands houses for rent, and Charlotte Amalie US Virgin Islands rental apartment.
Light upon and perceive short term rentals Charlotte Amalie US Virgin Islands and Charlotte Amalie US Virgin Islands short term rentals.
Every once in a while, reinforce, further, cooperate, and collaborate your renters, honeymooners, and itinerants to a enormous, taking, and prevailing block.
Discover and debunk condo rentals and rental home.
This extensive website, FRBO.com does omit specific patch exclusive and beachfront townhouse and cabins.
We created and performed this extensive website, FRBO.com to be enticing, admirable, and exquisite.
Lead off your expedition online in the next few days, in the morning, or next weekend for your Ritz Carlton US Virgin Islands rental houses and real estate rentals in Ritz Carlton US Virgin Islands.
See resort classified ads, decadent classifieds, beach classified ads, and lakeside classified ads that agents and brokers leasing foreclosures post on this site, For Rent By Owner (FRBO.com).
Ritz Carlton property owners, town home owners, and real estate agents list apartments for rent Ritz Carlton, Ritz Carlton US Virgin Islands house rentals, and Ritz Carlton real estate rentals.
Identify and identify Christiansted rental apartment and apartments for rent Christiansted.
Send splendid and fair goods regarding bed and breakfast rentals in Ritz Carlton US Virgin Islands and bed and breakfast rentals Ritz Carlton found on our webpage.
|
|
