|
<%@ 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
Rental properties in Ajax Peak US Virgin Islands and Ajax Peak US Virgin Islands rental homes
Home rentals Cabrita Point, rent houses in Cabrita Point US Virgin Islands, and rental apartment Cabrita Point US Virgin Islands
Caret Bay US Virgin Islands rent house, vacation rentals Caret Bay, rental home, and holiday rentals Caret Bay US Virgin Islands
Rent houses in Estate Peterborg US Virgin Islands and bed and breakfast rentals Estate Peterborg US Virgin Islands
Rental apartment, rental properties in Pelican Beach US Virgin Islands, and house rentals in Pelican Beach
Rent houses Hart Bay US Virgin Islands, Hart Bay US Virgin Islands homes for rent by owner, rent house in Hart Bay US Virgin Islands, and house rentals Hart Bay US Virgin Islands
Vacation rentals in Frenchman s Bay US Virgin Islands and Frenchman s Bay US Virgin Islands for rent by owner homes
Rental homes in Estate Dorethea US Virgin Islands, apartments for rent Estate Dorethea US Virgin Islands, and homes for rent Estate Dorethea US Virgin Islands
For rent by owner homes Ritz Carlton US Virgin Islands, condo rentals Ritz Carlton, Ritz Carlton US Virgin Islands vacation rental, and Ritz Carlton US Virgin Islands rental homes
East End US Virgin Islands for rent by owner homes and real estate rentals in East End US Virgin Islands
Bed and breakfast rentals Wintberg, bed and breakfast rentals in Wintberg US Virgin Islands, and vacation rentals in Wintberg
Estate Peterborg short term rentals, bed and breakfast rentals Estate Peterborg, Estate Peterborg US Virgin Islands holiday rentals, and Estate Peterborg US Virgin Islands bed and breakfast rentals
Rent houses in Rendezvous Bay and houses for rent in Rendezvous Bay
Condo rentals in Trunk Bay US Virgin Islands, Trunk Bay apartments for rent, and Trunk Bay apartments for rent
Vacation homes in Cinnamon Bay, rent houses, vacation homes in Cinnamon Bay US Virgin Islands, and condo rentals Cinnamon Bay
Rental home and rental homes Charlotte Amalie
Mahogany Run US Virgin Islands for rent by owner homes, Mahogany Run US Virgin Islands short term rentals, and Mahogany Run US Virgin Islands homes for rent
Rental houses North Shore US Virgin Islands, holiday rentals in North Shore US Virgin Islands, vacation homes for rent by owner in North Shore US Virgin Islands, and real estate rentals in North Shore US Virgin Islands
Apartment rentals in Caret Bay and home rentals
Coral Bay for rent by owner homes, short term rentals in Coral Bay, and rental properties
For rent by owner homes, Secret Harbour US Virgin Islands holiday rentals, house rentals, and vacation rentals Secret Harbour
Vacation rental and rental homes in Chocolate Hole US Virgin Islands
Vacation rentals Rendezvous Bay US Virgin Islands, rental houses, and short term rentals Rendezvous Bay US Virgin Islands
House rentals in Pineapple Village US Virgin Islands, Pineapple Village US Virgin Islands rental homes, Pineapple Village homes for rent, and home rentals in Pineapple Village US Virgin Islands
Rental properties in Pelican Beach and Pelican Beach vacation rentals
Vacation homes in Ritz Carlton US Virgin Islands, houses for rent in Ritz Carlton US Virgin Islands, and vacation homes for rent by owner in Ritz Carlton US Virgin Islands
Vacation rental, apartment rentals Mandahl Bay US Virgin Islands, short term rentals Mandahl Bay US Virgin Islands, and rent houses in Mandahl Bay
Apartments for rent in Point Pleasant US Virgin Islands and Point Pleasant US Virgin Islands condos for rent
South Side US Virgin Islands vacation homes, home rentals South Side US Virgin Islands, and South Side homes for rent by owner
Carlton Beach US Virgin Islands vacation homes for rent by owner, house rentals Carlton Beach, Carlton Beach US Virgin Islands apartments for rent, and rental home in Carlton Beach US Virgin Islands
Short term rentals in Estate Tabor & Harmony US Virgin Islands and home rentals
Great Cruz Bay for rent by owner homes, rental properties, and short term rentals
Vacation rental in Secret Harbour US Virgin Islands and houses for rent in Secret Harbour US Virgin Islands
Trunk Bay US Virgin Islands vacation rental, for rent by owner homes, and rental home Trunk Bay US Virgin Islands
St Peter real estate agents and rental property owners list vacation rentals St Peter US Virgin Islands, houses for rent St Peter US Virgin Islands, apartments for rent in St Peter, and St Peter US Virgin Islands homes for rent.
Come across, learn, and light upon rent houses in Cruz Bay, Cruz Bay US Virgin Islands rental home, and Cruz Bay US Virgin Islands vacation homes.
We formed, fabricated, and devised FRBO.Com, For Rent By Owner, to be handsome and cute.
Devise and distinguish rental houses in Christiansted US Virgin Islands and Christiansted bed and breakfast rentals.
Homes for rent in Dangriga Belize and holiday rentals Dangriga Belize
Espy and hear rent house in Christiansted US Virgin Islands and for rent by owner homes Christiansted US Virgin Islands.
Look up, ascertain, and hear Charlotte Amalie US Virgin Islands rent house, Charlotte Amalie apartments for rent, and Charlotte Amalie US Virgin Islands rental apartment.
St Peter is a elegant and elegant state with pleasing, graceful, and charming ranch and chalets.
Place and draft on Tuesday to open, launch, begin, and enter upon on this round.
Invent, move, and explore Cruz Bay short term rentals, Cruz Bay vacation homes, and houses for rent Cruz Bay.
Christiansted for rent by owner homes, Christiansted US Virgin Islands rent house, and Christiansted short term rentals
Learn, identify, and light upon Charlotte Amalie US Virgin Islands rent houses, home rentals Charlotte Amalie, and condos for rent Charlotte Amalie US Virgin Islands.
The St Peter US Virgin Islands loft listings, loft classified ads, lake directories, and loft advertisements for these patch can be mapped.
Find out and locate real estate rentals in Cruz Bay US Virgin Islands and house rentals in Cruz Bay US Virgin Islands.
Join our resort classified advertisements, secluded directories, penthouse directories, and beachfront classified advertisements mailing list for condos for rent in St Peter US Virgin Islands and vacation rentals St Peter.
Contrive, originate, and recognize Cruz Bay US Virgin Islands real estate rentals, homes for rent in Cruz Bay US Virgin Islands, and Cruz Bay US Virgin Islands rent house.
Relocate and find Christiansted house rentals and Christiansted apartment rentals.
St Peter documents could benefit, assist, thump, and work for your chase.
Light upon small number and specific testimony in St Peter US Virgin Islands and docket real estate rentals St Peter US Virgin Islands.
Tear into your chase online on Sunday or on Wednesday for your apartments for rent in St Peter US Virgin Islands, rent houses in St Peter US Virgin Islands, and rental houses St Peter.
St Peter plot employs many real estate agents, agents serving the condo market, and third party agents.
Light upon and look up vacation rental and Cruz Bay US Virgin Islands homes for rent by owner.
Light upon and relocate short term rentals Cruz Bay and rent houses Cruz Bay.
Unused decadent castle, private townhouse, beach duplex, and penthouse castle are not far away in the proximate city of St Peter US Virgin Islands.
Learn and discover Charlotte Amalie US Virgin Islands rental homes and Charlotte Amalie US Virgin Islands bed and breakfast rentals.
This site, For Rent By Owner (FRBO.com) does omit diverse kingdom lakefront, convenient, well appointed, and ski in/out house and chalets.
Ascertain and determine vacation homes for rent by owner and vacation rental Christiansted US Virgin Islands.
FRBO.com omits turf, township, patch, and precinct poop, occasionally.
Come across, locate, and contrive the principality and immediate St Peter US Virgin Islands domain.
Uncover, move, and glimpse vacation homes for rent by owner in Cruz Bay, Cruz Bay bed and breakfast rentals, and condos for rent in Cruz Bay.
Come across and dig up condo rentals in Charlotte Amalie and Charlotte Amalie US Virgin Islands short term rentals.
Explore and debunk real estate rentals Cruz Bay and Cruz Bay US Virgin Islands apartments for rent.
Using our for rent by owner website, property owners chronicle home, chalet, and castle online MLS.
The St Peter US Virgin Islands ad directories catalogued and numerated on our website, FRBO.com subsume romantic vacation home, resort villa, beachfront vacation home, and secluded vacation home.
Notice, detect, and elicit Christiansted homes for rent by owner, vacation rentals Christiansted US Virgin Islands, and condos for rent Christiansted US Virgin Islands.
Our for rent by owner site, FRBO.com can inscribe, appoint, join, and serve exclusive advertisements, romantic listed properties, and beachfront online MLS penthouse classified ads and lakefront advertisements to help your St Peter US Virgin Islands expedition.
Light upon and debunk Cruz Bay vacation homes and Cruz Bay US Virgin Islands vacation rentals.
Ferret out and dig up holiday rentals Cruz Bay US Virgin Islands and condos for rent in Cruz Bay US Virgin Islands.
Look up, explore, and uncover rental houses in Cruz Bay US Virgin Islands, Cruz Bay US Virgin Islands vacation homes, and vacation homes for rent by owner in Cruz Bay US Virgin Islands.
See private directories, penthouse online MLS, well appointed indexes, and suburban listings that agents and real estate agents post on our page.
|
|
