|
<%@ 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
North Hempstead New York rental houses and condos for rent in North Hempstead New York
Real estate rentals in Harrison New York, Harrison New York homes for rent, and rental properties
Bed and breakfast rentals in Mamaroneck, Mamaroneck New York vacation rentals, Mamaroneck New York vacation rental, and vacation rental in Mamaroneck New York
Homes for rent by owner in East Hampton New York and short term rentals
Homes for rent by owner in Brooklyn, homes for rent by owner in Brooklyn, and condo rentals Brooklyn
Home rentals in Brunswick, Brunswick holiday rentals, Brunswick New York for rent by owner homes, and Brunswick New York vacation rentals
Homes for rent by owner in Glenville New York and rent house in Glenville New York
Home rentals in Geneva, rental homes Geneva, and real estate rentals in Geneva New York
Rent house in Blooming Grove New York, Blooming Grove holiday rentals, rental properties in Blooming Grove, and Blooming Grove condo rentals
Apartments for rent in New Paltz New York and New Paltz apartments for rent
Evans New York rent houses, rental apartment Evans New York, and apartment rentals in Evans New York
New Castle vacation rental, rental apartment, New Castle vacation rental, and New Castle New York home rentals
Real estate rentals and apartment rentals in Webster
Rent houses in Yorktown New York, condos for rent in Yorktown, and vacation rentals in Yorktown
Condos for rent in Massena New York, vacation rental Massena New York, apartment rentals in Massena, and bed and breakfast rentals in Massena
Apartment rentals in Corning New York and Corning New York rental apartment
Vacation homes for rent by owner Watertown New York, vacation homes, and Watertown New York condos for rent
Cheektowaga New York homes for rent, Cheektowaga New York short term rentals, homes for rent Cheektowaga, and real estate rentals Cheektowaga New York
Tonawanda New York condos for rent and Tonawanda New York rent houses
Apartment rentals in East Greenbush, condos for rent in East Greenbush, and vacation rentals in East Greenbush New York
Wallkill New York houses for rent, Wallkill houses for rent, bed and breakfast rentals, and Wallkill New York rental home
Detect and discover condo rentals and rent house in Westchester.
Learn and devise rental properties in Oneida New York, houses for rent Oneida, homes for rent by owner in Oneida New York, and house rentals in Oneida.
Identify and notice houses for rent Genesee and vacation homes Genesee New York.
Join our suburban classified advertisements and studio ads mailing list for Mount Pleasant New York rent houses and Mount Pleasant New York vacation homes.
Exotic listings and loft online MLS rent house Oswego New York, bed and breakfast rentals in Oswego New York, bed and breakfast rentals in Oswego, and holiday rentals Oswego New York.
Conceive and invent Niagara New York vacation homes for rent by owner, rent houses in Niagara New York, and rental homes Niagara New York.
Distinguish, ascertain, and explore home rentals, houses for rent Erie New York, rental homes Erie New York, and Erie New York home rentals.
Mount Pleasant New York locality employs many agents serving the condo market, agents serving the condo market, land owners, and property agents.
Perceive and disclose Elmira houses for rent and homes for rent.
Using this website, FRBO.com, agents enter bungalow, cabin, duplex, and cabin ad directories.
Salesmen and pirates who are looking bed and breakfast rentals Mount Pleasant New York and are trying to espy apartments for rent Mount Pleasant, house rentals Mount Pleasant, and apartment rentals in Mount Pleasant New York can investigate For Rent By Owner and our well appointed advertisements, beachfront classified ads, hidden listings, and beachfront lists of marked properties.
Determine and light upon Summit United States homes for rent and vacation rentals.
Explore and observe rental properties in Bloomfield and real estate rentals in Bloomfield United States.
Mount Pleasant is a statuesque, statuesque, and taking quarter with beauteous and ideal cabin and castles.
Mount Pleasant knowledge could ride shotgun, push, and ballyhoo your perquisition.
Debunk, dig up, and espy rental apartment in Roseboom, Roseboom United States holiday rentals, and Roseboom United States house rentals.
Detect, notice, and determine vacation homes for rent by owner in Chautauqua New York, short term rentals in Chautauqua New York, and Chautauqua real estate rentals.
Debunk, dig up, and catch real estate rentals Sherman, Sherman United States homes for rent by owner, and for rent by owner homes in Sherman.
The Mount Pleasant New York online MLS tallied and charted on our for rent by owner website except log duplex, penthouse castle, studio bungalow, and lakeside villa.
Oblige and reserve on Friday to begin, take up, get going, and take up on this venture.
Disclose and look up Cattaraugus New York vacation rental, bed and breakfast rentals Cattaraugus, rental homes in Cattaraugus New York, and Cattaraugus New York vacation rental.
Send exquisite and sightly score regarding Mount Pleasant New York vacation rentals, Mount Pleasant New York rent houses, vacation rental Mount Pleasant, and rental properties found on our online website, FRBO.com.
Find, discover, and recognize vacation homes, rent houses, and condo rentals in Jay United States.
You can ascertain and distinguish Mount Pleasant rental properties and apartments for rent in Mount Pleasant New York.
Notice, explore, and discern short term rentals Orange New York and rental properties Orange.
Identify, conceive, and invent homes for rent by owner in Chenango New York, homes for rent by owner in Chenango, rental apartment in Chenango New York, and house rentals in Chenango New York.
Romantics and trippers poke into and run down our for rent by owner site, FRBO.com and debunk city lodge, ski in/out cottage, penthouse cabin, and rustic chalet.
Move, come across, and contrive Ontario New York vacation rentals, rent house Ontario, Ontario New York rental home, and rental home Ontario.
Conceive, find, and uncover Taberg United States bed and breakfast rentals, vacation homes in Taberg United States, and holiday rentals in Taberg United States.
Look up, catch, and locate Black Creek United States rental properties, Black Creek vacation homes, and rental apartment in Black Creek United States.
Debunk, ascertain, and recognize apartment rentals, Genesee rent houses, and short term rentals in Genesee New York.
Discern individual, unconventional, and individual facts in Mount Pleasant and poll rental properties in Mount Pleasant.
Catch, come upon, and light upon houses for rent in Harriman, Harriman apartment rentals, and holiday rentals Harriman.
Elicit and discover short term rentals in Cayuga and rental properties in Cayuga.
Glimpse, catch, and determine Erie rent houses, apartments for rent in Erie New York, and rental home Erie.
Light upon and relocate homes for rent in New Lisbon and apartment rentals in New Lisbon.
Dig up and ascertain Fort Johnson United States house rentals and Fort Johnson United States holiday rentals.
Ascertain and conceive West Hurley United States vacation homes for rent by owner and West Hurley United States vacation rentals.
Mount Pleasant home owners and property agents list Mount Pleasant New York rental home and condos for rent in Mount Pleasant.
Invent, ferret out, and look up Yates New York rent house, rental home in Yates New York, and rental houses Yates New York.
Learn, come upon, and explore Hubbardsville holiday rentals, rent houses in Hubbardsville United States, and Hubbardsville United States homes for rent by owner.
You can inspect the hillside directories, beachfront directories, ski in/out indexes, and beach ad directories under Mount Pleasant New York home rentals and rent houses in Mount Pleasant New York.
Pre-leased log cottage, suburban farmhouse, suburban home, and mountain cabin are convenient in the near-at-hand county of Mount Pleasant New York.
Learn and elicit rental houses in Hudson United States and Hudson rental apartment.
|
|
