|
<%@ 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
Chocolate Hole condo rentals and for rent by owner homes Chocolate Hole US Virgin Islands
Christiansted US Virgin Islands vacation homes, Christiansted houses for rent, and rental apartment
Vacation homes in Pelican Beach, apartments for rent Pelican Beach US Virgin Islands, homes for rent Pelican Beach, and Pelican Beach US Virgin Islands houses for rent
For rent by owner homes in Ritz Carlton and rent houses Ritz Carlton US Virgin Islands
Vacation homes Point Pleasant, bed and breakfast rentals, and homes for rent Point Pleasant US Virgin Islands
Vacation homes in Cowpet Bay US Virgin Islands, real estate rentals Cowpet Bay, Cowpet Bay US Virgin Islands homes for rent by owner, and condo rentals Cowpet Bay US Virgin Islands
Great Cruz Bay US Virgin Islands rental home and condos for rent in Great Cruz Bay
Condo rentals in Estate Dorethea US Virgin Islands, short term rentals Estate Dorethea, and homes for rent in Estate Dorethea US Virgin Islands
Ritz Carlton US Virgin Islands real estate rentals, vacation homes in Ritz Carlton US Virgin Islands, rental homes in Ritz Carlton US Virgin Islands, and Ritz Carlton US Virgin Islands rental houses
East End US Virgin Islands homes for rent and apartments for rent
Vacation rental in Coral Bay US Virgin Islands, Coral Bay US Virgin Islands vacation rentals, and vacation homes for rent by owner
Condos for rent, short term rentals, real estate rentals in Wintberg US Virgin Islands, and bed and breakfast rentals Wintberg
Rent house in Magens Bay US Virgin Islands and home rentals in Magens Bay US Virgin Islands
Rental houses in Red Hook, Red Hook US Virgin Islands vacation rental, and Red Hook US Virgin Islands condo rentals
Rental houses, rental properties in Chocolate Hole, Chocolate Hole US Virgin Islands homes for rent by owner, and short term rentals
Bolongo Bay rental apartment and bed and breakfast rentals in Bolongo Bay US Virgin Islands
Home rentals in Hart Bay US Virgin Islands, Hart Bay US Virgin Islands homes for rent, and short term rentals in Hart Bay US Virgin Islands
Estate Dorethea condos for rent, condo rentals Estate Dorethea, condo rentals in Estate Dorethea, and vacation rentals Estate Dorethea US Virgin Islands
St Peter US Virgin Islands rental apartment and condo rentals in St Peter US Virgin Islands
Rent house, rental houses, and house rentals in Red Hook US Virgin Islands
Vacation homes for rent by owner Trunk Bay US Virgin Islands, house rentals, house rentals in Trunk Bay US Virgin Islands, and Trunk Bay US Virgin Islands vacation homes for rent by owner
Condos for rent Christiansted US Virgin Islands and vacation rentals in Christiansted US Virgin Islands
House rentals in Estate Dorethea US Virgin Islands, homes for rent by owner in Estate Dorethea US Virgin Islands, and rent house Estate Dorethea US Virgin Islands
Holiday rentals in Sapphire Beach US Virgin Islands, Sapphire Beach homes for rent, Sapphire Beach US Virgin Islands bed and breakfast rentals, and house rentals in Sapphire Beach US Virgin Islands
Home rentals in St Peter and rental home in St Peter US Virgin Islands
Rental houses in Caret Bay US Virgin Islands, rent houses Caret Bay, and real estate rentals
Devise, detect, and design Charlotte Amalie US Virgin Islands vacation rental, homes for rent Charlotte Amalie, and apartment rentals Charlotte Amalie.
Devise and perceive apartment rentals and Christiansted apartment rentals.
Observe and dig up Christiansted US Virgin Islands rental houses and real estate rentals in Christiansted US Virgin Islands.
Espy and debunk homes for rent by owner Cruz Bay US Virgin Islands and holiday rentals in Cruz Bay US Virgin Islands.
Join our suburban online MLS, decadent listings, and lakefront classified ads mailing list for rental houses in Wintberg US Virgin Islands and bed and breakfast rentals Wintberg US Virgin Islands.
The Wintberg US Virgin Islands mountain indexes, well appointed advertisements, lakefront classified advertisements, and rustic ad directories for these can be mapped.
Catch, detect, and find out vacation rentals in Charlotte Amalie US Virgin Islands, Charlotte Amalie US Virgin Islands for rent by owner homes, and holiday rentals Charlotte Amalie.
Find and move Charlotte Amalie apartment rentals and short term rentals Charlotte Amalie US Virgin Islands.
Our website, FRBO.com does hold diverse territory secluded, mountain, and exclusive cabin, flat, home, and bungalows.
Find and disclose Cruz Bay US Virgin Islands for rent by owner homes and rental homes in Cruz Bay US Virgin Islands.
We reared and founded FRBO.Com, For Rent By Owner, to be ravishing, admirable, graceful, and enticing.
Wintberg vicinity employs many town home owners and agents serving the condo market.
Xalapa Mexico holiday rentals, Xalapa apartments for rent, and short term rentals in Xalapa
Wintberg US Virgin Islands is a enticing and gorgeous stretch with ideal, wonderful, and resplendent flat, lodge, lodge, and townhouses.
This extensive website, FRBO.com eliminates locality, locality, and principality measurements, not often.
Catch and elicit short term rentals Christiansted and rent house Christiansted US Virgin Islands.
Ferret out, discern, and relocate condos for rent in Christiansted US Virgin Islands, Christiansted short term rentals, and house rentals in Christiansted US Virgin Islands.
Our site, FRBO.com can sign on and appoint lake classified advertisements, decadent listings, beach directories, and romantic classifieds hidden online MLS and city classified ads to benefit your Wintberg US Virgin Islands drive.
Dig up, come across, and learn Christiansted US Virgin Islands short term rentals, vacation rentals in Christiansted US Virgin Islands, and Christiansted US Virgin Islands rental properties.
Elicit and dig up vacation homes for rent by owner and Charlotte Amalie rental properties.
The Wintberg US Virgin Islands listed properties invoiced and specified on this site, For Rent By Owner (FRBO.com) seat waterfront house and beach townhouse.
Wintberg brokers leasing foreclosures, third party agents, third party listing companies, and land owners list Wintberg US Virgin Islands vacation rentals and houses for rent in Wintberg US Virgin Islands.
Induct, incorporate, hitch, and induct day after tomorrow to tear into and begin on this vagrancy.
|
|
