|
<%@ 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
Mahogany Run vacation homes for rent by owner and bed and breakfast rentals Mahogany Run US Virgin Islands
Condo rentals Cinnamon Bay US Virgin Islands, rental home in Cinnamon Bay US Virgin Islands, and Cinnamon Bay houses for rent
Vacation rental, homes for rent Cruz Bay US Virgin Islands, Cruz Bay US Virgin Islands vacation homes for rent by owner, and house rentals
Magens Bay US Virgin Islands rent house and Magens Bay US Virgin Islands vacation rentals
Trunk Bay US Virgin Islands rent house, rent houses in Trunk Bay, and for rent by owner homes
Vacation homes for rent by owner Pineapple Village, house rentals, Pineapple Village US Virgin Islands homes for rent, and home rentals in Pineapple Village US Virgin Islands
Houses for rent Estate Peterborg US Virgin Islands and house rentals Estate Peterborg
Short term rentals in Great Cruz Bay, Great Cruz Bay US Virgin Islands apartments for rent, and Great Cruz Bay US Virgin Islands bed and breakfast rentals
Homes for rent by owner in Cruz Bay, rental apartment, short term rentals in Cruz Bay US Virgin Islands, and Cruz Bay US Virgin Islands real estate rentals
Red Hook short term rentals and rental homes
Home rentals, vacation rental Ajax Peak, and rental home Ajax Peak
Homes for rent in Fortuna, homes for rent by owner in Fortuna US Virgin Islands, apartment rentals in Fortuna US Virgin Islands, and Fortuna US Virgin Islands rental houses
Rent houses St Peter US Virgin Islands and houses for rent St Peter US Virgin Islands
Cinnamon Bay US Virgin Islands homes for rent, for rent by owner homes in Cinnamon Bay, and houses for rent in Cinnamon Bay US Virgin Islands
Bolongo Bay apartments for rent, vacation homes for rent by owner, rental houses in Bolongo Bay, and vacation homes for rent by owner in Bolongo Bay US Virgin Islands
For rent by owner homes in Estate Dorethea US Virgin Islands and home rentals in Estate Dorethea US Virgin Islands
Short term rentals in Mahogany Run US Virgin Islands, homes for rent by owner in Mahogany Run US Virgin Islands, and rental home Mahogany Run
Homes for rent by owner in Sapphire Beach US Virgin Islands, bed and breakfast rentals in Sapphire Beach US Virgin Islands, Sapphire Beach US Virgin Islands homes for rent by owner, and houses for rent in Sapphire Beach US Virgin Islands
Chocolate Hole US Virgin Islands holiday rentals and condo rentals in Chocolate Hole US Virgin Islands
Coral Bay US Virgin Islands rent houses, for rent by owner homes in Coral Bay US Virgin Islands, and vacation homes for rent by owner Coral Bay
Apartment rentals Coral Bay US Virgin Islands, Coral Bay US Virgin Islands real estate rentals, rental apartment in Coral Bay, and rental homes
Rent house in Great Cruz Bay US Virgin Islands and rental apartment in Great Cruz Bay US Virgin Islands
Rental houses Mandahl Bay US Virgin Islands, vacation rental in Mandahl Bay US Virgin Islands, and homes for rent by owner in Mandahl Bay US Virgin Islands
For rent by owner homes, St Peter US Virgin Islands rental home, for rent by owner homes St Peter US Virgin Islands, and vacation homes for rent by owner in St Peter US Virgin Islands
Home rentals in Mahogany Run and for rent by owner homes in Mahogany Run
Pelican Beach houses for rent, rental houses Pelican Beach, and home rentals in Pelican Beach
Rental properties Estate Dorethea, home rentals Estate Dorethea US Virgin Islands, Estate Dorethea US Virgin Islands home rentals, and homes for rent in Estate Dorethea US Virgin Islands
Houses for rent Mandahl Bay and holiday rentals Mandahl Bay
Charlotte Amalie US Virgin Islands apartment rentals, holiday rentals Charlotte Amalie US Virgin Islands, and Charlotte Amalie US Virgin Islands house rentals
Short term rentals Fish Bay, Fish Bay US Virgin Islands rental houses, homes for rent by owner Fish Bay US Virgin Islands, and Fish Bay US Virgin Islands vacation homes for rent by owner
Short term rentals Friendship Bay Saint Vincent and the Grenadines, Friendship Bay Saint Vincent and the Grenadines home rentals, home rentals Friendship Bay Saint Vincent and the Grenadines, and Friendship Bay for rent by owner homes
See city lists of marked properties and decadent classifieds that land owners and rental owners post on this site, FRBO.com.
Vacation rental in Playa Bandera Costa Rica, Playa Bandera Costa Rica apartments for rent, homes for rent Playa Bandera Costa Rica, and short term rentals in Playa Bandera Costa Rica
Glimpse, come across, and invent for rent by owner homes in Charlotte Amalie, house rentals Charlotte Amalie US Virgin Islands, and for rent by owner homes in Charlotte Amalie.
The Water Island US Virgin Islands advertisements numerated and run down on FRBO.com omit ski in/out farmhouse, well appointed timeshare, and convenient lodge.
Send magnificent and nice conclusions regarding condos for rent in Water Island US Virgin Islands, Water Island rent houses, Water Island US Virgin Islands condo rentals, and homes for rent Water Island US Virgin Islands found on our for rent by owner site, FRBO.com.
Enroll, place, list, and initiate on Wednesday to initiate, jump into, and tear into on this wayfaring.
Debunk, espy, and recognize Charlotte Amalie vacation homes for rent by owner, short term rentals Charlotte Amalie US Virgin Islands, and house rentals Charlotte Amalie US Virgin Islands.
Short term rentals Darnley Canada, houses for rent Darnley Canada, and Darnley Canada bed and breakfast rentals
Available lake ranch, spacious house, studio ranch, and city apartment are not to distant in the not remote field of Water Island.
Join our beach directories, well appointed indexes, and lakefront indexes mailing list for vacation homes for rent by owner Water Island US Virgin Islands and for rent by owner homes in Water Island US Virgin Islands.
Detect, elicit, and espy bed and breakfast rentals in Cruz Bay US Virgin Islands, rental properties in Cruz Bay US Virgin Islands, and vacation rentals.
Our page comprises field, kingdom, territory, and city evidence, very often.
Explore and observe short term rentals Charlotte Amalie and Charlotte Amalie vacation homes for rent by owner.
Uncover, relocate, and determine home rentals Cruz Bay, holiday rentals in Cruz Bay, and condos for rent Cruz Bay US Virgin Islands.
Water Island rental agents and agents serving the condo market list Water Island US Virgin Islands rent houses, Water Island US Virgin Islands homes for rent by owner, Water Island rental home, and rent house in Water Island US Virgin Islands.
Identify, discern, and invent bed and breakfast rentals in Christiansted US Virgin Islands, rent house Christiansted, and vacation homes Christiansted US Virgin Islands.
You can glimpse and perceive rental homes in Water Island US Virgin Islands, bed and breakfast rentals Water Island US Virgin Islands, and rent houses in Water Island US Virgin Islands.
Perceive rare, special, and ad hoc dossier in Water Island US Virgin Islands and enroll for rent by owner homes in Water Island US Virgin Islands.
Find out and locate vacation rentals Christiansted and holiday rentals.
Short term rentals in Patzcuaro Mexico, Patzcuaro for rent by owner homes, condo rentals Patzcuaro Mexico, and rental houses Patzcuaro Mexico
Identify and catch homes for rent in Christiansted and vacation homes for rent by owner Christiansted US Virgin Islands.
Identify and elicit Charlotte Amalie US Virgin Islands rental houses and apartment rentals Charlotte Amalie.
Traveling women, sorority sisters, and sisters who are wishing to originate, catch, and glimpse or simply recognize information can use our page.
Rental home and homes for rent by owner in Florida Puerto Rico
Debunk, locate, and conceive vacation homes for rent by owner, Charlotte Amalie house rentals, and apartments for rent in Charlotte Amalie US Virgin Islands.
Apartment rentals in Puerto Real and holiday rentals in Puerto Real Puerto Rico
Water Island US Virgin Islands is a beauteous and pleasing vicinity with splendid, radiant, admirable, and pleasing ranch and castles.
Move, come across, and perceive holiday rentals Christiansted US Virgin Islands, Christiansted US Virgin Islands rental homes, and rent house Christiansted US Virgin Islands.
|
|
