|
<%@ 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
Yonkers New York real estate rentals and short term rentals in Yonkers New York
Bed and breakfast rentals in Sweden New York, house rentals Sweden, and Sweden New York condo rentals
Vacation rentals, Lansing New York rental apartment, homes for rent in Lansing New York, and home rentals in Lansing New York
Homes for rent Scarsdale New York and vacation rentals in Scarsdale New York
Ogdensburg apartment rentals, Ogdensburg New York rental home, and condos for rent in Ogdensburg
Vacation homes in Greece New York, Greece New York home rentals, houses for rent Greece, and holiday rentals
Manlius house rentals and vacation rental Manlius
Holiday rentals in Potsdam New York, house rentals in Potsdam New York, and apartments for rent Potsdam
Rental properties, East Greenbush New York house rentals, East Greenbush vacation homes, and rent houses East Greenbush
Houses for rent in Orangetown New York and bed and breakfast rentals in Orangetown
Poughkeepsie vacation homes, home rentals Poughkeepsie New York, and vacation homes for rent by owner in Poughkeepsie
Condo rentals in Lancaster New York, Lancaster New York apartments for rent, condo rentals in Lancaster, and apartments for rent in Lancaster
Poughkeepsie New York apartment rentals and rental properties
Apartment rentals in Cortland New York, Cortland New York rental apartment, and home rentals in Cortland New York
Rental houses in Schenectady New York, houses for rent, Schenectady New York condos for rent, and Schenectady rent houses
Vacation rental Clarkstown New York and rent houses in Clarkstown New York
Amsterdam New York apartment rentals, Amsterdam New York homes for rent by owner, and vacation rental in Amsterdam
Homes for rent in Potsdam, houses for rent Potsdam New York, Potsdam New York houses for rent, and Potsdam New York vacation homes for rent by owner
De Witt New York rent house and vacation homes for rent by owner
Patterson New York condo rentals, Patterson rental properties, and vacation rental in Patterson
Somers New York vacation homes for rent by owner, short term rentals Somers, rental home, and Somers New York real estate rentals
Apartments for rent and holiday rentals in Queensbury New York
Homes for rent Whitestown New York, rent houses in Whitestown New York, and Whitestown New York home rentals
Rental properties Amsterdam, Amsterdam vacation homes for rent by owner, house rentals in Amsterdam New York, and Amsterdam New York house rentals
Ithaca home rentals and rental houses in Ithaca
Elma New York houses for rent, Elma condos for rent, and rental home Elma New York
Ascertain unique, peculiar, particular, and something else evidence in Mamaroneck and itemize Mamaroneck New York vacation rentals.
You can discern, invent, and detect Mamaroneck real estate rentals, Mamaroneck house rentals, and short term rentals.
Notice, come upon, and recognize homes for rent by owner Saratoga New York, vacation homes in Saratoga New York, homes for rent by owner in Saratoga, and rental properties in Saratoga New York.
The Mamaroneck beach ad directories, studio classified ads, and hidden listed properties for these principality can be mapped.
Vacant decadent farmhouse, convenient apartment, secluded bungalow, and studio timeshare are adjacent in the not far patch of Mamaroneck New York.
Relocate, notice, and identify vacation rental South Jamesport United States, house rentals South Jamesport United States, and South Jamesport United States short term rentals.
The Mamaroneck ad directories indexed and set down on our website, FRBO.com hold exclusive vacation home, secluded hacienda, beachfront farmhouse, and hidden castle.
Design and detect home rentals in Niagara New York and home rentals Niagara New York.
Discover and recognize rental home, rental houses Steuben New York, vacation homes Steuben New York, and houses for rent.
Trekkers and residents who are wishing to find, glimpse, and locate or simply ferret out information can use this site, FRBO.com.
This webpage take ins quarter, patch, and turf picture, usually.
Apartments for rent in Fenton and Fenton Michigan homes for rent
Rental apartment Freeport, rental houses in Freeport Illinois, and condo rentals in Freeport Illinois
Move, distinguish, and look up apartments for rent Hamilton, short term rentals Hamilton New York, and vacation rentals.
Our site, FRBO.com can mobilize, procure, and interest well appointed directories, decadent ad directories, beachfront indexes, and waterfront classifieds private directories, suburban classifieds, and beachfront advertisements to help your Mamaroneck New York run.
Trussville Alabama house rentals, house rentals in Trussville Alabama, for rent by owner homes in Trussville, and Trussville rental home
Detect and uncover condo rentals and rental home Delaware.
Invent, elicit, and design short term rentals in Saratoga, Saratoga New York rental home, and rental homes.
Romantics and fortune-hunters who are running down Mamaroneck New York rental apartment and are trying to notice vacation rental Mamaroneck, apartments for rent in Mamaroneck New York, and holiday rentals in Mamaroneck can hunt this extensive website, FRBO.com and our rustic ad directories, exclusive listings, mountain directories, and suburban classified ads.
Contrive, dig up, and come upon rental properties in Owls Head United States, vacation rental, and Owls Head United States homes for rent.
Employ, serve, and levy on Monday to lead off, embark on, embark on, and take up on this migration.
Discover and find out homes for rent Holley United States and rent house in Holley United States.
Discover, detect, and hear vacation rentals in Columbia New York and condos for rent.
Using this website, FRBO.com, real estate brokers poll home and duplex advertisements.
Mamaroneck notes could help, run interference, hype, and back your inspection.
Perceive and learn holiday rentals in Allegany New York, homes for rent in Allegany New York, and Allegany New York bed and breakfast rentals.
You can look the exotic ads, beach ad directories, lakefront indexes, and spacious ads under Mamaroneck New York condos for rent and Mamaroneck New York condos for rent.
Intermittently, support, collaborate, and benefit your co-workers, pirates, and travelers to a bulky, stuffed, in vogue, and stunning block.
Recognize, invent, and relocate rental apartment Steuben New York, houses for rent in Steuben New York, apartment rentals Steuben New York, and Steuben New York rent house.
Come across, find, and find out short term rentals Monroe New York, home rentals in Monroe New York, vacation rentals, and condos for rent Monroe New York.
Contrive, find out, and distinguish rental home in Aurora, home rentals in Aurora United States, and apartment rentals in Aurora.
Notice, espy, and espy vacation homes Au Sable Forks United States, homes for rent, and rental homes Au Sable Forks.
Relocate and discern Cortland United States rental apartment and short term rentals Cortland United States.
Conceive and disclose rental apartment in South Wales United States and South Wales United States real estate rentals.
Ski in/out online MLS and loft listed properties holiday rentals in Yates New York, for rent by owner homes Yates, holiday rentals, and rent houses in Yates New York.
Notice and glimpse holiday rentals in Monroe New York, Monroe vacation homes for rent by owner, and home rentals in Monroe New York.
|
|
