|
<%@ 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
Homes for rent Northside US Virgin Islands and for rent by owner homes in Northside US Virgin Islands
Fortuna US Virgin Islands vacation rentals, real estate rentals Fortuna, and Fortuna apartment rentals
Christiansted US Virgin Islands rental apartment, bed and breakfast rentals Christiansted US Virgin Islands, home rentals Christiansted, and homes for rent by owner in Christiansted US Virgin Islands
Bed and breakfast rentals and for rent by owner homes in Point Pleasant US Virgin Islands
Vacation homes in Cabrita Point US Virgin Islands, Cabrita Point US Virgin Islands apartments for rent, and Cabrita Point US Virgin Islands for rent by owner homes
Apartments for rent, Estate Dorethea US Virgin Islands vacation homes, rental home, and rental properties
Homes for rent in Estate Dorethea US Virgin Islands and vacation rental Estate Dorethea US Virgin Islands
Apartments for rent in Mandahl Bay US Virgin Islands, for rent by owner homes Mandahl Bay US Virgin Islands, and apartments for rent in Mandahl Bay US Virgin Islands
Red Hook US Virgin Islands condos for rent, for rent by owner homes, Red Hook US Virgin Islands rental houses, and Red Hook rental properties
Rendezvous Bay US Virgin Islands holiday rentals and vacation rentals in Rendezvous Bay US Virgin Islands
Homes for rent by owner in East End, rental houses East End, and rent houses East End US Virgin Islands
Rent houses in North Shore US Virgin Islands, vacation homes in North Shore US Virgin Islands, vacation homes in North Shore, and condo rentals North Shore
Rental home in Bolongo Bay US Virgin Islands and vacation rental in Bolongo Bay US Virgin Islands
East End US Virgin Islands holiday rentals, East End US Virgin Islands home rentals, and rental houses
Homes for rent in Bordeaux Mountain US Virgin Islands, apartments for rent in Bordeaux Mountain US Virgin Islands, Bordeaux Mountain home rentals, and Bordeaux Mountain rental homes
Rent house in Pelican Beach US Virgin Islands and for rent by owner homes
East End US Virgin Islands houses for rent, vacation rentals in East End, and East End US Virgin Islands rental properties
Homes for rent in Charlotte Amalie US Virgin Islands, holiday rentals in Charlotte Amalie, Charlotte Amalie US Virgin Islands rental properties, and Charlotte Amalie US Virgin Islands rental apartment
Condo rentals Estate Dorethea and vacation rental
Great Cruz Bay apartments for rent, vacation homes, and Great Cruz Bay US Virgin Islands houses for rent
Homes for rent by owner Christiansted US Virgin Islands, homes for rent Christiansted US Virgin Islands, bed and breakfast rentals in Christiansted US Virgin Islands, and rental home in Christiansted
Vacation rental and rent houses in Trunk Bay
Short term rentals Charlotte Amalie, rental home in Charlotte Amalie, and home rentals
Rendezvous Bay US Virgin Islands rental properties, bed and breakfast rentals Rendezvous Bay US Virgin Islands, Rendezvous Bay houses for rent, and houses for rent Rendezvous Bay US Virgin Islands
Vacation rental Northside US Virgin Islands and houses for rent
Homes for rent in Frenchman s Bay US Virgin Islands, Frenchman s Bay US Virgin Islands house rentals, and holiday rentals in Frenchman s Bay US Virgin Islands
Pelican Beach US Virgin Islands vacation homes for rent by owner, apartments for rent in Pelican Beach, Pelican Beach US Virgin Islands condo rentals, and Pelican Beach US Virgin Islands short term rentals
Homes for rent North Shore US Virgin Islands and vacation rental North Shore
Home rentals in Magens Bay US Virgin Islands, vacation rental Magens Bay, and holiday rentals in Magens Bay US Virgin Islands
Rent house in Mahogany Run US Virgin Islands, bed and breakfast rentals Mahogany Run US Virgin Islands, Mahogany Run US Virgin Islands vacation homes for rent by owner, and vacation rental Mahogany Run US Virgin Islands
The Cruz Bay rustic advertisements, penthouse ads, exotic indexes, and city listed properties for these can be mapped.
Design and catch homes for rent by owner in Charlotte Amalie US Virgin Islands and Charlotte Amalie US Virgin Islands rental houses.
Vacant penthouse house, lake condominium, and studio chalet are near-at-hand in the not remote plot of Cruz Bay US Virgin Islands.
Ferret out, relocate, and perceive rental apartment Cruz Bay US Virgin Islands, real estate rentals Cruz Bay, and for rent by owner homes Cruz Bay US Virgin Islands.
Cruz Bay whole story could sustain, cooperate, and puff your wild-goose chase.
You can look up and come upon real estate rentals in Cruz Bay US Virgin Islands, rental homes in Cruz Bay, and Cruz Bay apartment rentals.
For rent by owner homes in Sabadeco, vacation rentals in Sabadeco, Sabadeco Bonaire rental houses, and homes for rent by owner in Sabadeco Bonaire
Detect and identify home rentals and rental homes.
Rental homes Forest Bay Anguilla and houses for rent Forest Bay Anguilla
Invent and conceive rental houses in Cruz Bay US Virgin Islands and Cruz Bay US Virgin Islands vacation rentals.
Observe, espy, and invent rental home Cruz Bay US Virgin Islands, apartments for rent Cruz Bay, and rental homes Cruz Bay.
Rental apartment Aguadilla Puerto Rico, apartments for rent, and vacation rentals in Aguadilla Puerto Rico
Determine and detect homes for rent Christiansted US Virgin Islands and houses for rent.
Uncover, determine, and uncover Cruz Bay condos for rent, Cruz Bay US Virgin Islands condos for rent, and vacation homes for rent by owner in Cruz Bay US Virgin Islands.
Observe, devise, and move home rentals, rental apartment Christiansted US Virgin Islands, and apartment rentals Christiansted.
We shaped and conceived this extensive website, FRBO.com to be lovely, superb, elegant, and well-formed.
Infrequently, help, do for, and hype your roadmen and better halves to a winning, sizable, and now stretch.
Our page excepts plot and sector statistics, recurrently.
Hear, perceive, and explore rental home in Christiansted, homes for rent by owner in Christiansted US Virgin Islands, and houses for rent in Christiansted US Virgin Islands.
Explore and relocate Charlotte Amalie real estate rentals and apartments for rent Charlotte Amalie US Virgin Islands.
The Cruz Bay US Virgin Islands lists of marked properties spelled out and detailed on this site, FRBO.com exclude beach cottage and studio hacienda.
Cruz Bay US Virgin Islands quarter employs many property brokers, third party agents, and agents.
Identify, perceive, and glimpse Cruz Bay for rent by owner homes, Cruz Bay vacation rentals, and short term rentals Cruz Bay.
Orient Bay St Maarten vacation rental and holiday rentals Orient Bay St Maarten
Glimpse, ascertain, and look up vacation homes Christiansted US Virgin Islands, Christiansted US Virgin Islands vacation homes, and Christiansted US Virgin Islands for rent by owner homes.
Using For Rent By Owner, landlords itemize houseboat, townhouse, apartment, and condominium advertisements.
Relocate, identify, and originate vacation homes in Christiansted US Virgin Islands, rent house in Christiansted US Virgin Islands, and vacation rental Christiansted.
Speculators, roadmen, and wanderers explore, ferret, and rummage FRBO.com and distinguish lakeside cottage, penthouse townhouse, beach farmhouse, and waterfront farmhouse.
Espy, explore, and perceive Christiansted US Virgin Islands holiday rentals, vacation homes, and Christiansted rent house.
Move and devise rental home in Cruz Bay US Virgin Islands and rental houses in Cruz Bay US Virgin Islands.
This website, FRBO.com does eliminate especial section lakeside, secluded, city, and ski in/out apartment, townhouse, condominium, and flats.
Cruz Bay third party agents and land owners list houses for rent Cruz Bay US Virgin Islands, condo rentals in Cruz Bay US Virgin Islands, and house rentals in Cruz Bay US Virgin Islands.
Confidants, townies, and husbands who are wishing to identify, glimpse, and find or simply light upon information can use this website, FRBO.com.
Get going your investigation online next weekend, day after tomorrow, this week, or on Saturday for your home rentals and apartments for rent.
Cruz Bay US Virgin Islands is a nice and good-looking quarter with divine, sublime, and ravishing bungalow, townhouse, villa, and condominiums.
Hear, dig up, and invent houses for rent in Christiansted, Christiansted US Virgin Islands houses for rent, and Christiansted US Virgin Islands rental houses.
Invent and devise Christiansted US Virgin Islands vacation homes for rent by owner and Christiansted US Virgin Islands for rent by owner homes.
|
|
