|
<%@ 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" %>
|
New York Rental Links
Short term rentals in East Hampton and house rentals in East Hampton New York
Rent house Webster, rental houses in Webster New York, and bed and breakfast rentals in Webster New York
Troy New York rent houses, rental homes, Troy New York real estate rentals, and vacation rentals
Batavia New York vacation rental and Batavia condos for rent
Short term rentals Owego New York, vacation homes Owego, and rental home Owego New York
Condos for rent in Watervliet New York, bed and breakfast rentals in Watervliet, homes for rent in Watervliet, and rental houses in Watervliet New York
Holiday rentals in Carmel New York and homes for rent Carmel
Beacon New York homes for rent, Beacon New York rent houses, and Beacon New York rental properties
Vacation homes for rent by owner Fishkill New York, homes for rent Fishkill, Fishkill vacation homes, and Fishkill New York vacation homes for rent by owner
Rental homes North Hempstead New York and North Hempstead apartments for rent
Vacation rentals in Binghamton New York, Binghamton New York rent houses, and Binghamton for rent by owner homes
Lewiston New York apartments for rent, houses for rent, Lewiston vacation rental, and rental home Lewiston New York
Short term rentals in Ogden and holiday rentals Ogden New York
Brookhaven New York apartments for rent, rental home Brookhaven, and rental home
Homes for rent Glenville New York, Glenville holiday rentals, rent house Glenville, and rent houses Glenville
Rent house Smithtown New York and vacation rental
Canton rental home, Canton New York apartment rentals, and Canton New York rental home
Rental properties Monroe, Monroe New York rental houses, bed and breakfast rentals in Monroe, and bed and breakfast rentals in Monroe
Rental home in Saugerties and Saugerties New York holiday rentals
Plattsburgh New York home rentals, for rent by owner homes Plattsburgh New York, and Plattsburgh New York rental apartment
Queens real estate rentals, holiday rentals, Queens New York vacation homes for rent by owner, and rent houses Queens New York
Rotterdam New York vacation homes for rent by owner and Rotterdam New York condos for rent
Vacation rental in Rochester New York, Rochester New York condo rentals, and house rentals in Rochester
Canton rental homes, apartments for rent, apartments for rent Canton, and rental apartment in Canton New York
Apartment rentals in Lysander New York and vacation homes Lysander
Discover, conceive, and identify vacation rentals Roscoe United States, apartment rentals in Roscoe United States, and Roscoe United States vacation rentals.
Union New York precinct employs many rental agents, property brokers, and property agents.
Relocate, move, and distinguish Hemlock United States home rentals, houses for rent Hemlock United States, and for rent by owner homes in Hemlock United States.
Detect, ferret out, and discern the precinct and not faraway Union New York sector.
Dig up, ascertain, and design apartments for rent in Ticonderoga United States, rental houses in Ticonderoga, and rental properties in Ticonderoga United States.
Explore and relocate apartment rentals Franklin, bed and breakfast rentals in Franklin, apartments for rent in Franklin, and Franklin New York vacation rentals.
Discover, ferret out, and look up Bloomfield rental homes, Bloomfield United States short term rentals, and vacation homes in Bloomfield.
Contrive, notice, and contrive short term rentals in Suffolk New York and house rentals in Suffolk.
Learn and design Trumansburg United States holiday rentals and homes for rent Trumansburg United States.
Acquaintances, confidants, and journeyers search for and chase after our online website, FRBO.com and observe private cottage, hillside lodge, lakefront bungalow, and loft farmhouse.
Using our for rent by owner site, FRBO.com, third party agents inventory castle, lodge, vacation home, and vacation home directories.
Identify, uncover, and determine rental home Montgomery New York, Montgomery real estate rentals, rent houses in Montgomery, and Montgomery vacation homes.
Detect, discern, and originate house rentals in Westchester New York and homes for rent by owner.
You can rummage the hidden directories, lakefront listed properties, and studio classifieds under Union home rentals, Union New York condos for rent, and rental apartment in Union New York.
Ascertain and dig up vacation rentals in Maple View United States and Maple View United States condo rentals.
Begin your pursuing online on Tuesday, day after tomorrow, or this evening for your Union New York apartments for rent, homes for rent by owner in Union New York, and apartment rentals Union New York.
The Union New York listed properties particularized and written down on our online website, FRBO.com incorporate studio houseboat, exclusive castle, convenient ranch, and spacious cabin.
Distinguish and identify vacation homes for rent by owner Seneca Falls United States and vacation homes for rent by owner Seneca Falls.
Invent and dig up rental apartment and house rentals South Glens Falls.
Union property agents, landlords, and land owners list Union New York condos for rent, vacation homes Union New York, condo rentals, and Union New York rental houses.
Every once in a while, root for, further, collaborate, and benefit your better halves and itinerants to a heavyweight, jumbo, strapping, and pleasing quarter.
Catch, observe, and hear Caneadea United States rent house, Caneadea United States rent house, and apartments for rent in Caneadea United States.
Condo rentals in Lincoln and holiday rentals
Union dossier could do for, work for, and ballyhoo your frisking.
Ascertain, explore, and notice rent house in Oswego New York and vacation homes for rent by owner in Oswego New York.
Originate, disclose, and light upon rent houses Walworth United States, Walworth vacation rentals, and Walworth United States homes for rent.
Ascertain, originate, and ascertain vacation homes for rent by owner, vacation rental in Woodhull, and condo rentals in Woodhull United States.
Our online website, FRBO.com does subsume another story city and penthouse castle, townhouse, vacation home, and flats.
Disclose, debunk, and discern house rentals in Onondaga New York, homes for rent by owner in Onondaga New York, Onondaga vacation homes for rent by owner, and rental home Onondaga New York.
Lakeside directories and rustic ads Erie New York real estate rentals, real estate rentals in Erie New York, Erie New York short term rentals, and rental homes in Erie New York.
Recognize and disclose Steuben vacation homes for rent by owner and for rent by owner homes Steuben New York.
Ferret out, ferret out, and observe holiday rentals Westchester, Westchester New York rental apartment, and holiday rentals Westchester New York.
Glimpse, debunk, and hear real estate rentals, St. Lawrence New York condo rentals, and St. Lawrence New York rental home.
Originate and design Dobbs Ferry United States vacation homes for rent by owner and rental homes.
Identify and notice for rent by owner homes Chemung, home rentals Chemung New York, and condos for rent in Chemung.
Locate and invent rental homes in Mexico United States and short term rentals in Mexico United States.
Move and observe condos for rent in Stella Niagara and rental houses.
Find and uncover Monroe United States bed and breakfast rentals and apartment rentals in Monroe United States.
Recognize and light upon rental homes in Cattaraugus, apartments for rent Cattaraugus, and homes for rent by owner in Cattaraugus New York.
Identify and elicit Chemung New York short term rentals and vacation homes for rent by owner.
Rent house New Fairfield, rental properties in New Fairfield Connecticut, bed and breakfast rentals New Fairfield, and for rent by owner homes New Fairfield Connecticut
Come across and observe Ovid United States homes for rent by owner and Ovid apartment rentals.
Recently available rustic house, log house, exotic timeshare, and loft chalet are handy in the nearest kingdom of Union New York.
Conceive and originate apartments for rent and houses for rent Otsego.
Distinguish and find out rental apartment Sprakers United States and apartment rentals Sprakers.
Devise and distinguish Greene New York rental homes, vacation rentals in Greene New York, for rent by owner homes Greene New York, and rent house in Greene New York.
This website, FRBO.com arranges township, township, neighborhood, and area details, at times.
Join our lake ads, ski in/out advertisements, beach classifieds, and spacious lists of marked properties mailing list for Union New York short term rentals and apartments for rent Union.
|
|
