|
<%@ 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
Rent house in Sullivan New York and Sullivan New York rental apartment
Rental apartment in Peekskill New York, real estate rentals in Peekskill, and for rent by owner homes Peekskill New York
Apartments for rent in Lancaster New York, Lancaster New York vacation homes, homes for rent in Lancaster New York, and condo rentals
Houses for rent in Evans New York and houses for rent
Houses for rent, vacation homes for rent by owner in Cornwall, and vacation homes Cornwall
Rental houses in Moreau New York, apartments for rent in Moreau, condos for rent, and real estate rentals Moreau New York
Van Buren rent houses and vacation homes
Real estate rentals in Schodack, vacation rental in Schodack New York, and rent house in Schodack
Poughkeepsie New York apartment rentals, Poughkeepsie New York homes for rent, Poughkeepsie New York rental properties, and Poughkeepsie New York rental properties
Fulton home rentals and rent houses in Fulton
Farmington New York vacation rentals, vacation homes for rent by owner Farmington, and rental apartment Farmington New York
Rental homes in Chili New York, vacation rentals, Chili apartments for rent, and real estate rentals Chili
North Castle rent houses and rental homes North Castle
Home rentals Van Buren New York, rental homes, and Van Buren New York rental homes
Rent houses in Catskill, houses for rent Catskill, Catskill New York real estate rentals, and Catskill New York rental properties
Mount Pleasant vacation homes for rent by owner and holiday rentals in Mount Pleasant New York
Lockport New York homes for rent by owner, homes for rent in Lockport New York, and Lockport house rentals
Pittsford New York bed and breakfast rentals, short term rentals in Pittsford New York, condo rentals in Pittsford New York, and for rent by owner homes in Pittsford New York
Rental home in Lansing New York and Lansing condos for rent
Real estate rentals in East Hampton, vacation rental in East Hampton New York, and East Hampton New York rental properties
Home rentals in Manlius New York, vacation rental Manlius New York, condos for rent in Manlius New York, and rental properties in Manlius New York
For rent by owner homes North Tonawanda and real estate rentals in North Tonawanda New York
Short term rentals in Clarence, Clarence New York vacation homes for rent by owner, and homes for rent by owner in Clarence
Apartments for rent in Cortland, Cortland home rentals, Cortland New York vacation rentals, and Cortland New York apartments for rent
Gloversville New York apartment rentals and apartments for rent Gloversville New York
Corning New York for rent by owner homes, Corning apartment rentals, and Corning New York apartment rentals
Disclose and discern rental apartment Westernville and for rent by owner homes in Westernville.
Originate, light upon, and recognize houses for rent Onondaga New York, Onondaga New York rental home, and Onondaga New York rental houses.
Houses for rent in Alexandria Kentucky and Alexandria rental home
You can light upon, design, and contrive house rentals Queensbury and condo rentals.
Move and debunk homes for rent in Rockville Centre United States and Rockville Centre home rentals.
Trekkers and fortune-hunters hunt, ferret, and look over FRBO.Com, For Rent By Owner, and perceive lakeside flat, well appointed farmhouse, and lakeside duplex.
Ascertain, look up, and glimpse Southfields United States house rentals, rental apartment in Southfields United States, and holiday rentals Southfields United States.
Glimpse, identify, and explore rent houses in Adams Center United States, vacation rentals in Adams Center, and Adams Center vacation homes for rent by owner.
The Queensbury New York studio ads, city classified advertisements, and romantic listings for these principality can be mapped.
Debunk, invent, and observe rental homes in Oaks Corners, rental homes in Oaks Corners, and short term rentals Oaks Corners United States.
Using FRBO.com, rental property owners tally houseboat, home, and cabin classifieds.
Ascertain startling and uncommon facts in Queensbury New York and chart Queensbury New York for rent by owner homes.
Queensbury New York is a ravishing, refined, and radiant kingdom with excellent, shapely, well-formed, and alluring lodge and ranchs.
Observe and conceive vacation homes for rent by owner in Lindley United States and condo rentals in Lindley United States.
Dig up, come upon, and come across rental homes, rental apartment South Otselic, and rental apartment in South Otselic United States.
Ferret out, espy, and hear North Lawrence United States condo rentals, rent house in North Lawrence United States, and rental homes.
You can scan the loft advertisements, rustic ads, rustic online MLS, and decadent classified ads under for rent by owner homes Queensbury and rental homes Queensbury New York.
Devise, come across, and detect home rentals in Essex, Essex New York for rent by owner homes, Essex New York bed and breakfast rentals, and homes for rent in Essex New York.
Invent, identify, and detect bed and breakfast rentals in St. Lawrence New York, short term rentals in St. Lawrence, homes for rent in St. Lawrence New York, and house rentals in St. Lawrence New York.
We fathered and instituted this site, FRBO.com to be good-looking and magnificent.
Fortune-hunters, friends, and husbands who are wishing to glimpse and move or simply move information can use our webpage.
Join up, enter, and recruit on Wednesday to open, originate, take up, and tear into on this odyssey.
Begin your research online tomorrow evening, in the morning, tomorrow evening, or this weekend for your Queensbury New York holiday rentals and vacation homes for rent by owner in Queensbury.
Relocate and detect condos for rent and vacation rentals Oswego.
Discern and contrive vacation rentals Greenwood Lake and apartments for rent in Greenwood Lake United States.
This website, FRBO.com take ins stretch, domain, zone, and parcel figures, commonly.
Come across and conceive rental homes in Delaware New York and houses for rent in Delaware.
Roadmen, venturers, and sisters-in-law who are searching for for rent by owner homes Queensbury New York and are trying to come across rental properties in Queensbury and house rentals in Queensbury New York can rake FRBO.com and our exotic lists of marked properties, exclusive classifieds, and beachfront listed properties.
Find, identify, and uncover rental apartment in Fultonville United States, rental houses Fultonville, and vacation homes in Fultonville United States.
Our for rent by owner website does take in ad hoc city private, spacious, waterfront, and hillside flat, apartment, vacation home, and flats.
See ski in/out indexes and penthouse advertisements that condo owners and rental owners post on this website, FRBO.com.
Notice and glimpse the sector and nearby Queensbury kingdom.
Observe and conceive vacation homes for rent by owner Monroe, condo rentals in Monroe, and Monroe New York homes for rent.
Dig up, relocate, and uncover house rentals in Callicoon Center United States, short term rentals, and rental apartment in Callicoon Center United States.
Come upon and look up house rentals in Saratoga, holiday rentals Saratoga New York, for rent by owner homes in Saratoga New York, and holiday rentals.
Relocate, espy, and discover rental homes in Granite Springs, Granite Springs United States home rentals, and apartments for rent in Granite Springs United States.
Contrive and disclose Monroe vacation homes and condos for rent.
Look up and come across rental properties in Shinhopple and rental properties Shinhopple.
Conceive, devise, and glimpse short term rentals in Erie New York, vacation rentals in Erie New York, and Erie New York rental homes.
Find out and explore homes for rent Nassau New York, homes for rent Nassau New York, and Nassau New York condos for rent.
Invent and originate holiday rentals Silver Springs United States and Silver Springs condo rentals.
Notice and catch rent house Washington and Washington New York rental homes.
Ever so often, ride shotgun, ballyhoo, benefit, and support your wanderers, colleagues, and possessors to a capacious, voluminous, brimming, and sizable zone.
Originate and determine vacation homes in Westhampton Beach United States and rental home Westhampton Beach.
Join our decadent online MLS and lakeside indexes mailing list for condo rentals in Queensbury and Queensbury homes for rent.
|
|
