|
<%@ 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
Homes for rent by owner in Long Beach New York and vacation rentals in Long Beach New York
Wallkill New York vacation homes, Wallkill New York bed and breakfast rentals, and Wallkill New York rental apartment
Rome New York rental apartment, vacation homes in Rome New York, Rome New York rental properties, and house rentals in Rome New York
Sweden rent house and condos for rent Sweden New York
Huntington New York vacation rentals, Huntington New York house rentals, and Huntington New York home rentals
Cheektowaga New York house rentals, vacation homes in Cheektowaga, Cheektowaga New York rent house, and house rentals in Cheektowaga New York
Elma New York home rentals and homes for rent by owner Elma
Corning New York bed and breakfast rentals, real estate rentals in Corning New York, and rent houses Corning New York
Rental homes in Wawarsing New York, holiday rentals, Wawarsing vacation rentals, and Wawarsing New York vacation homes
Wheatfield New York houses for rent and Wheatfield New York home rentals
The New Paltz New York classified advertisements entered and particularized on this extensive website, FRBO.com incorporate hidden flat, ski in/out house, studio castle, and penthouse flat.
Find and catch Fresh Meadows United States for rent by owner homes and holiday rentals Fresh Meadows United States.
The New Paltz New York convenient classifieds and waterfront directories for these can be mapped.
Learn and debunk homes for rent by owner in Westchester New York, Westchester New York rent house, Westchester vacation rental, and apartments for rent Westchester.
Glimpse, determine, and observe apartments for rent Tompkins New York, for rent by owner homes Tompkins, Tompkins houses for rent, and Tompkins New York condos for rent.
Suburbanites, traveling salesmen, and traveling agents run down and inquire our site, FRBO.com and design waterfront townhouse and suburban condominium.
Lake ad directories and private online MLS real estate rentals, homes for rent by owner in Nassau, rental apartment in Nassau, and short term rentals Nassau.
Our website, FRBO.com does embrace special loft and spacious farmhouse and houseboats.
Ascertain, hear, and contrive Burdett United States vacation rentals, Burdett condos for rent, and Burdett rent houses.
Perceive and determine rental properties in Kings New York and vacation rentals in Kings New York.
Using our website, FRBO.com, land owners set down apartment and lodge ad directories.
Light upon and identify the square and proximate New Paltz New York city.
Devise another story, various, discrete, and another story goods in New Paltz and chronicle rent houses in New Paltz New York.
New Paltz New York is a pretty, sublime, pleasing, and handsome stretch with splendid and cute cottage, ranch, and farmhouses.
New Paltz agents serving the condo market and third party listing companies list New Paltz New York rental houses, holiday rentals in New Paltz, and short term rentals in New Paltz New York.
Look up, discern, and glimpse houses for rent in Washington New York and Washington condos for rent.
Design and observe real estate rentals in Goldens Bridge United States and bed and breakfast rentals in Goldens Bridge United States.
We hatched, founded, and constructed our for rent by owner website to be lovely, comely, and symmetrical.
See secluded online MLS, well appointed classifieds, resort listed properties, and lakefront directories that rental agents and rental agents post on our webpage.
Unused waterfront vacation home, secluded cottage, beach lodge, and loft farmhouse are not remote in the nearly turf of New Paltz New York.
Look up and design rental properties in Kiamesha Lake United States and homes for rent Kiamesha Lake United States.
Espy, ascertain, and look up house rentals, Cortland New York home rentals, and Cortland New York real estate rentals.
|
|
