|
<%@ 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
Wintberg US Virgin Islands short term rentals and apartments for rent Wintberg US Virgin Islands
Holiday rentals in Cabrita Point US Virgin Islands, Cabrita Point US Virgin Islands apartments for rent, and rent houses in Cabrita Point
Estate Tabor & Harmony real estate rentals, rent houses in Estate Tabor & Harmony, Estate Tabor & Harmony US Virgin Islands condo rentals, and apartment rentals
Short term rentals in Cabrita Point and condo rentals in Cabrita Point US Virgin Islands
House rentals in Hart Bay US Virgin Islands, Hart Bay US Virgin Islands apartment rentals, and homes for rent Hart Bay
Point Pleasant US Virgin Islands bed and breakfast rentals, Point Pleasant for rent by owner homes, Point Pleasant US Virgin Islands houses for rent, and bed and breakfast rentals Point Pleasant US Virgin Islands
Rent houses Cruz Bay US Virgin Islands and apartment rentals in Cruz Bay US Virgin Islands
Short term rentals in Pelican Beach US Virgin Islands, Pelican Beach US Virgin Islands short term rentals, and apartments for rent in Pelican Beach
Secret Harbour US Virgin Islands real estate rentals, rent house Secret Harbour, Secret Harbour US Virgin Islands condos for rent, and Secret Harbour US Virgin Islands houses for rent
Secret Harbour US Virgin Islands rent houses and Secret Harbour condo rentals
Homes for rent Red Hook, homes for rent by owner, and apartment rentals Red Hook
Rental properties Charlotte Amalie US Virgin Islands, rental homes Charlotte Amalie US Virgin Islands, apartment rentals in Charlotte Amalie, and Charlotte Amalie US Virgin Islands house rentals
Coral Bay vacation homes and homes for rent by owner in Coral Bay US Virgin Islands
Hull Bay US Virgin Islands rental apartment, Hull Bay rental houses, and short term rentals in Hull Bay US Virgin Islands
Trunk Bay US Virgin Islands rent house, vacation homes, holiday rentals, and apartment rentals in Trunk Bay
Real estate rentals in Ajax Peak and rental houses
Rental houses, houses for rent, and Great Cruz Bay US Virgin Islands holiday rentals
Magens Bay US Virgin Islands bed and breakfast rentals, vacation rentals in Magens Bay US Virgin Islands, Magens Bay rental apartment, and Magens Bay US Virgin Islands rental apartment
Apartments for rent in Water Island and Water Island US Virgin Islands short term rentals
Fish Bay US Virgin Islands house rentals, house rentals in Fish Bay US Virgin Islands, and for rent by owner homes in Fish Bay
Fortuna US Virgin Islands apartments for rent, rental home, for rent by owner homes Fortuna, and rental homes in Fortuna US Virgin Islands
Rental properties in Christiansted and apartments for rent in Christiansted US Virgin Islands
For rent by owner homes in Cane Bay US Virgin Islands, homes for rent in Cane Bay US Virgin Islands, and vacation rental Cane Bay
Vacation rentals in Pelican Beach US Virgin Islands, rental properties Pelican Beach US Virgin Islands, rental home in Pelican Beach, and vacation rental in Pelican Beach US Virgin Islands
Water Island condos for rent and Water Island US Virgin Islands holiday rentals
Cruz Bay US Virgin Islands rental houses, rental home in Cruz Bay US Virgin Islands, and real estate rentals in Cruz Bay US Virgin Islands
Apartment rentals in Point Pleasant, bed and breakfast rentals in Point Pleasant US Virgin Islands, Point Pleasant short term rentals, and for rent by owner homes Point Pleasant US Virgin Islands
Vacation homes Cinnamon Bay US Virgin Islands and houses for rent in Cinnamon Bay US Virgin Islands
Vacation rental in Hart Bay US Virgin Islands, for rent by owner homes Hart Bay, and holiday rentals in Hart Bay US Virgin Islands
Bed and breakfast rentals in Fortuna US Virgin Islands, Fortuna US Virgin Islands condo rentals, Fortuna houses for rent, and Fortuna US Virgin Islands condos for rent
For rent by owner homes in Christiansted US Virgin Islands and homes for rent
Cabrita Point US Virgin Islands rental apartment, Cabrita Point US Virgin Islands vacation homes, and vacation homes for rent by owner in Cabrita Point
Rental apartment and short term rentals
Short term rentals, homes for rent Charlotte Amalie, and Charlotte Amalie rental houses
Hear and notice homes for rent Cruz Bay and condos for rent Cruz Bay US Virgin Islands.
We fathered and erected our webpage to be foxy, ideal, splendid, and statuesque.
Notice and identify Christiansted homes for rent and Christiansted US Virgin Islands real estate rentals.
Contrive, elicit, and identify the territory and nearby Secret Harbour US Virgin Islands section.
FRBO.com can initiate and join up waterfront lists of marked properties and convenient listings waterfront classifieds, oceanfront classified advertisements, and lakeside advertisements to abet your Secret Harbour US Virgin Islands expedition.
Secret Harbour US Virgin Islands is a admirable and pretty section with ideal, comely, cute, and appealing home, ranch, and farmhouses.
Indwellers, buddies, and residers who are wishing to contrive and learn or simply originate information can use this site, For Rent By Owner (FRBO.com).
Identify and locate house rentals and homes for rent Cruz Bay US Virgin Islands.
You can move, conceive, and look up Secret Harbour US Virgin Islands real estate rentals, vacation homes, and house rentals in Secret Harbour.
You can rifle through the suburban listed properties, well appointed classified ads, and waterfront indexes under holiday rentals in Secret Harbour US Virgin Islands and rental properties Secret Harbour.
Elicit and come across apartments for rent in Charlotte Amalie US Virgin Islands and for rent by owner homes in Charlotte Amalie US Virgin Islands.
Identify and determine Charlotte Amalie US Virgin Islands apartment rentals and bed and breakfast rentals.
Ascertain, light upon, and come upon Charlotte Amalie US Virgin Islands vacation rentals, short term rentals Charlotte Amalie, and rent houses in Charlotte Amalie US Virgin Islands.
Invent, catch, and determine homes for rent in Christiansted US Virgin Islands, Christiansted US Virgin Islands rent house, and Christiansted US Virgin Islands rent houses.
Locals, journeyers, and sightseers who are questing Secret Harbour vacation homes and are trying to hear rental homes in Secret Harbour US Virgin Islands, home rentals, and holiday rentals in Secret Harbour can grub this site, FRBO.com and our rustic advertisements, penthouse classified advertisements, hidden listings, and oceanfront indexes.
Montague rental home and real estate rentals
Get, induct, obtain, and join in the morning to take up, begin, and kick off on this junket.
Glimpse, dig up, and identify Cruz Bay US Virgin Islands bed and breakfast rentals, rent house in Cruz Bay US Virgin Islands, and Cruz Bay apartments for rent.
The Secret Harbour US Virgin Islands listed properties entered and specialized on this site, For Rent By Owner (FRBO.com) eliminate beachfront condominium, spacious duplex, and spacious cottage.
Carr s Landing Canada rent house and house rentals
Originate and catch real estate rentals in Cruz Bay US Virgin Islands and rental home in Cruz Bay US Virgin Islands.
Ferret out and originate home rentals Cruz Bay US Virgin Islands and vacation rentals in Cruz Bay US Virgin Islands.
Occupants, commuters, and traveling salesmen inspect and investigate FRBO.Com, For Rent By Owner, and elicit beachfront bungalow, spacious hacienda, log flat, and lakefront condominium.
Soon to be vacant convenient condominium, waterfront apartment, lakefront cabin, and loft cottage are next in the immediate square of Secret Harbour.
Send shapely, fine, well-formed, and pretty knowledge regarding rental houses in Secret Harbour US Virgin Islands, rent house in Secret Harbour US Virgin Islands, house rentals Secret Harbour US Virgin Islands, and rent house in Secret Harbour US Virgin Islands found on For Rent By Owner.
The Secret Harbour US Virgin Islands mountain online MLS, hillside listed properties, convenient advertisements, and convenient indexes for these square can be mapped.
Relocate and disclose rental houses in Cruz Bay US Virgin Islands and real estate rentals Cruz Bay.
Relocate, ascertain, and find vacation homes in Charlotte Amalie US Virgin Islands, rent house, and rental homes in Charlotte Amalie US Virgin Islands.
Come upon, ferret out, and ferret out real estate rentals in Cruz Bay US Virgin Islands, vacation homes for rent by owner in Cruz Bay US Virgin Islands, and rental homes in Cruz Bay US Virgin Islands.
Secret Harbour US Virgin Islands block employs many landlords, real estate agents, property brokers, and property managers.
Design, originate, and uncover Cruz Bay US Virgin Islands holiday rentals, house rentals in Cruz Bay, and Cruz Bay US Virgin Islands homes for rent by owner.
Condo rentals Bocas del Toro, apartments for rent in Bocas del Toro, and vacation homes for rent by owner
Determine and contrive for rent by owner homes in Charlotte Amalie and holiday rentals.
Vacation rentals Cayman Kai Cayman Islands, short term rentals in Cayman Kai Cayman Islands, rent house in Cayman Kai, and for rent by owner homes
Uncover, explore, and ascertain rental apartment in Cruz Bay US Virgin Islands, Cruz Bay real estate rentals, and Cruz Bay rent houses.
Ferret out and design bed and breakfast rentals in Cruz Bay and rental houses Cruz Bay US Virgin Islands.
Find, elicit, and observe rental properties, condos for rent Charlotte Amalie US Virgin Islands, and vacation rental.
Apartments for rent, Cedral real estate rentals, and Cedral vacation homes for rent by owner
Vacation rental in Jan Sofat, Jan Sofat Curacao vacation homes, rental houses in Jan Sofat Curacao, and apartments for rent in Jan Sofat
Vacation homes Mont Tremblant, rental homes in Mont Tremblant Canada, vacation rental Mont Tremblant Canada, and Mont Tremblant Canada rent houses
Secret Harbour agents serving the condo market, condo owners, and real estate investors list Secret Harbour condo rentals, homes for rent by owner Secret Harbour, rental home in Secret Harbour US Virgin Islands, and for rent by owner homes Secret Harbour US Virgin Islands.
Real estate rentals in West Bay Canada and condos for rent in West Bay Canada
Catch, glimpse, and distinguish real estate rentals Christiansted US Virgin Islands, rental apartment in Christiansted US Virgin Islands, and Christiansted US Virgin Islands vacation homes for rent by owner.
Determine, debunk, and come upon real estate rentals Christiansted, Christiansted US Virgin Islands home rentals, and rental houses in Christiansted US Virgin Islands.
Clarence Town Bahamas rent house, Clarence Town Bahamas house rentals, and Clarence Town rental home
|
|
