|
<%@ 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
Red Hook US Virgin Islands rental apartment and Red Hook rent house
Cruz Bay US Virgin Islands rental houses, condo rentals Cruz Bay, and rental houses Cruz Bay
House rentals, Mandahl Bay US Virgin Islands house rentals, house rentals in Mandahl Bay US Virgin Islands, and homes for rent by owner in Mandahl Bay US Virgin Islands
Rental properties Red Hook and rental properties in Red Hook
Rental apartment in Estate Dorethea US Virgin Islands, real estate rentals, and rental apartment in Estate Dorethea
Homes for rent by owner, real estate rentals Chocolate Hole, real estate rentals Chocolate Hole, and apartment rentals
Houses for rent in Carlton Beach US Virgin Islands and rent houses in Carlton Beach
Apartment rentals Magens Bay US Virgin Islands, Magens Bay US Virgin Islands vacation rental, and vacation rentals in Magens Bay
Apartment rentals in Secret Harbour, homes for rent by owner Secret Harbour, homes for rent, and Secret Harbour US Virgin Islands apartments for rent
Apartments for rent Hull Bay and apartment rentals in Hull Bay US Virgin Islands
Fish Bay US Virgin Islands rental houses, rent house in Fish Bay US Virgin Islands, and homes for rent in Fish Bay US Virgin Islands
Red Hook US Virgin Islands short term rentals, home rentals in Red Hook US Virgin Islands, Red Hook US Virgin Islands real estate rentals, and Red Hook rent house
Rental home and home rentals in Mandahl Bay US Virgin Islands
Apartment rentals, Pelican Beach US Virgin Islands short term rentals, and Pelican Beach US Virgin Islands houses for rent
Caret Bay US Virgin Islands rental apartment, vacation rental Caret Bay US Virgin Islands, Caret Bay short term rentals, and Caret Bay US Virgin Islands home rentals
Cruz Bay rental properties and Cruz Bay bed and breakfast rentals
Devise, observe, and light upon Cruz Bay home rentals, home rentals, and condos for rent.
Using this website, FRBO.com, rental property owners enter farmhouse, condominium, house, and home classified advertisements.
Identify, ferret out, and observe house rentals, rental home Charlotte Amalie, and rent house in Charlotte Amalie US Virgin Islands.
Northside property agents, brokers leasing foreclosures, town home owners, and rental agents list vacation homes in Northside and Northside home rentals.
You can ascertain, contrive, and light upon homes for rent by owner in Northside US Virgin Islands and short term rentals in Northside US Virgin Islands.
Glimpse and learn Cruz Bay bed and breakfast rentals and Cruz Bay US Virgin Islands vacation homes.
Come across, identify, and discover home rentals in Cruz Bay US Virgin Islands, home rentals Cruz Bay, and Cruz Bay condo rentals.
Discern and distinguish house rentals Christiansted US Virgin Islands and Christiansted rent house.
See mountain classified advertisements, lakeside advertisements, and resort listings that condo owners and home owners post on this site, FRBO.com.
Northside US Virgin Islands neighborhood employs many condo owners, property managers, landlords, and third party agents.
You can prospect the hidden classified advertisements, log indexes, waterfront ad directories, and ski in/out directories under rental homes in Northside US Virgin Islands, rental properties in Northside US Virgin Islands, and apartments for rent in Northside.
The Northside US Virgin Islands exclusive directories, suburban directories, exotic advertisements, and lake ad directories for these can be mapped.
Relocate, design, and invent Christiansted rental properties, vacation homes for rent by owner Christiansted US Virgin Islands, and houses for rent.
|
|
