|
<%@ 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
Holiday rentals in Trunk Bay US Virgin Islands and homes for rent by owner Trunk Bay
Point Pleasant US Virgin Islands apartment rentals, holiday rentals in Point Pleasant, and rental homes in Point Pleasant US Virgin Islands
Vacation rentals, Hull Bay US Virgin Islands real estate rentals, vacation rentals, and apartment rentals in Hull Bay US Virgin Islands
Pelican Beach US Virgin Islands rental apartment and condos for rent Pelican Beach US Virgin Islands
Real estate rentals Charlotte Amalie US Virgin Islands, for rent by owner homes in Charlotte Amalie US Virgin Islands, and rent house Charlotte Amalie
Point Pleasant vacation rentals, Point Pleasant US Virgin Islands apartment rentals, Point Pleasant US Virgin Islands rent house, and homes for rent in Point Pleasant US Virgin Islands
Bordeaux Mountain US Virgin Islands house rentals and for rent by owner homes in Bordeaux Mountain US Virgin Islands
Rental home in Red Hook US Virgin Islands, rent house, and Red Hook US Virgin Islands rental apartment
Rental houses Pelican Beach US Virgin Islands, Pelican Beach vacation homes, house rentals in Pelican Beach US Virgin Islands, and vacation rental in Pelican Beach
Short term rentals and Cinnamon Bay US Virgin Islands home rentals
Water Island US Virgin Islands house rentals, Water Island US Virgin Islands rent houses, and bed and breakfast rentals Water Island
Short term rentals in East End US Virgin Islands, vacation homes for rent by owner in East End US Virgin Islands, apartments for rent East End US Virgin Islands, and condo rentals
Homes for rent Pineapple Village and apartments for rent
Homes for rent Carlton Beach, house rentals Carlton Beach US Virgin Islands, and Carlton Beach US Virgin Islands house rentals
Condo rentals Fish Bay US Virgin Islands, apartments for rent in Fish Bay US Virgin Islands, Fish Bay condo rentals, and rental apartment Fish Bay
Condos for rent in Cabrita Point and vacation homes in Cabrita Point US Virgin Islands
Rental houses in Fish Bay, apartments for rent in Fish Bay, and Fish Bay bed and breakfast rentals
Trippers and migrants who are shaking down houses for rent East End and are trying to ferret out condo rentals in East End, rental houses East End, and condo rentals in East End can scour FRBO.Com, For Rent By Owner, and our mountain directories and resort classified ads.
Join our well appointed classifieds, well appointed listed properties, and spacious indexes mailing list for houses for rent in East End US Virgin Islands and East End US Virgin Islands rental home.
The East End US Virgin Islands ad directories pegged and kept counted on our for rent by owner site, FRBO.com arrange romantic ranch, loft hacienda, loft ranch, and spacious apartment.
See spacious classified advertisements, resort classified advertisements, and suburban online MLS that town home owners and agents serving the condo market post on our online website, FRBO.com.
Catch, ferret out, and ferret out Cruz Bay homes for rent, Cruz Bay US Virgin Islands rental houses, and condos for rent in Cruz Bay US Virgin Islands.
Learn and identify rent houses Charlotte Amalie and rental home in Charlotte Amalie.
East End US Virgin Islands locality employs many home owners, brokers leasing foreclosures, real estate investors, and rental agents.
East End is a refined, lovely, ideal, and delightful vicinity with nice, foxy, pleasing, and classy castle, home, ranch, and condominiums.
Ferret out, dig up, and debunk Charlotte Amalie US Virgin Islands home rentals, rental apartment in Charlotte Amalie US Virgin Islands, and home rentals in Charlotte Amalie US Virgin Islands.
Acquaintances, schoolmates, and colleagues who are wishing to determine and distinguish or simply glimpse information can use FRBO.com.
Occupiers, hikers, and inhabitants cast about and grub our online website, FRBO.com and discern beach farmhouse, log home, suburban apartment, and hillside bungalow.
Dig up and find out Christiansted US Virgin Islands for rent by owner homes and rental properties in Christiansted US Virgin Islands.
Identify, learn, and elicit homes for rent by owner, rental properties Cruz Bay US Virgin Islands, and vacation homes for rent by owner.
We contrived, originated, and parented this website, FRBO.com to be fine, well-formed, and marvelous.
Come upon and find out the quarter and not far East End US Virgin Islands kingdom.
Ascertain, invent, and learn apartments for rent in Cruz Bay US Virgin Islands, rental homes, and homes for rent in Cruz Bay US Virgin Islands.
|
|
