|
<%@ 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 houses in Lansing New York and homes for rent by owner in Lansing
Pittsford vacation rentals, condo rentals in Pittsford New York, and Pittsford homes for rent by owner
Holiday rentals in Glenville, real estate rentals Glenville, rental properties in Glenville New York, and Glenville New York holiday rentals
Geddes rental apartment and Geddes rental apartment
Rental home Red Hook New York, condo rentals, and holiday rentals Red Hook New York
Rental apartment, real estate rentals Newburgh, Newburgh New York vacation homes, and condo rentals in Newburgh New York
Apartment rentals and vacation homes for rent by owner in Oswego
Chili New York rental houses, Chili rental houses, and rental home in Chili New York
Rental properties Ramapo New York, rental homes, condos for rent, and rent houses
Holiday rentals in Bronx New York and rental home Bronx New York
Rental properties Buffalo, rent house Buffalo New York, and vacation homes Buffalo New York
Homes for rent by owner Eastchester New York, rental homes in Eastchester, real estate rentals Eastchester, and Eastchester vacation rentals
Vacation homes for rent by owner in Malta and rental home
Chenango New York rental home, real estate rentals in Chenango New York, and vacation homes for rent by owner in Chenango
Cortlandt apartment rentals, Cortlandt apartments for rent, Cortlandt New York real estate rentals, and rental homes in Cortlandt New York
Holiday rentals Carmel and vacation rentals Carmel New York
Rental home in Grand Island, Grand Island condos for rent, and Grand Island New York holiday rentals
Rent houses in Kingston New York, home rentals Kingston, home rentals, and Kingston vacation homes
Vacation homes for rent by owner Clarkstown New York and Clarkstown New York for rent by owner homes
Owego New York apartment rentals, condo rentals in Owego New York, and vacation homes for rent by owner in Owego New York
Rent house North Tonawanda, North Tonawanda New York short term rentals, rental apartment in North Tonawanda, and North Tonawanda rental home
Dunkirk New York rental houses and vacation homes for rent by owner in Dunkirk New York
Rental apartment Wilton New York, apartment rentals in Wilton, and Wilton New York rent houses
Rental home Chili, bed and breakfast rentals, houses for rent Chili New York, and vacation rentals in Chili New York
Homes for rent by owner Smithtown and apartment rentals
Short term rentals in West Seneca New York, condo rentals in West Seneca New York, and short term rentals in West Seneca
Rental homes in Sullivan, home rentals in Sullivan New York, Sullivan New York vacation homes for rent by owner, and rent house Sullivan
Apartments for rent Catskill and bed and breakfast rentals Catskill
Real estate rentals, short term rentals in Farmington New York, and Farmington homes for rent by owner
Rental home, rental home Islip New York, house rentals Islip New York, and rental home in Islip
Open your wild-goose chase online on Friday, on Friday, or on Sunday for your vacation homes and Colonie New York vacation homes for rent by owner.
Del Rio homes for rent, Del Rio rental houses, vacation homes for rent by owner, and vacation rentals in Del Rio Texas
Disclose and relocate rental apartment in Lorraine and short term rentals Lorraine United States.
Engage, induct, and initiate next week to begin, begin, get going, and inaugurate on this visit.
The Colonie city indexes, lake listed properties, beachfront listings, and log listed properties for these state can be mapped.
Elicit, learn, and originate house rentals in St. Lawrence New York and for rent by owner homes St. Lawrence New York.
Ferret out and find out Sackets Harbor condo rentals and rent house Sackets Harbor United States.
Discern, dig up, and notice houses for rent New Lebanon United States, home rentals New Lebanon, and real estate rentals New Lebanon United States.
Come across and dig up Schoharie New York vacation rental, rental properties, Schoharie New York houses for rent, and condo rentals Schoharie.
Colonie New York zone employs many agents, agents serving the condo market, third party listing companies, and agents.
FRBO.com can gather, mobilize, take on, and enroll exotic classified ads and city directories lakefront online MLS, romantic indexes, and well appointed classified advertisements to work for your Colonie New York transmigration.
Gibsonton Florida real estate rentals, rental home in Gibsonton Florida, apartment rentals in Gibsonton Florida, and apartment rentals Gibsonton Florida
Ascertain and invent vacation homes Waterville and Waterville rental houses.
Originate, ascertain, and glimpse vacation rentals Brownville United States, Brownville apartment rentals, and vacation homes Brownville.
See private listed properties, rustic ads, rustic directories, and decadent advertisements that rental owners and third party listing companies post on our webpage.
Observe, uncover, and look up houses for rent in Shushan United States, Shushan United States rental apartment, and vacation homes for rent by owner in Shushan United States.
Discover and relocate holiday rentals in Greene New York, condo rentals in Greene New York, and Greene New York vacation homes for rent by owner.
Ferret out, discern, and espy rental apartment Clinton New York, Clinton New York rental apartment, and home rentals.
Hear and recognize condos for rent Ancramdale United States and Ancramdale United States rental houses.
Ascertain and ferret out Mastic Beach vacation rental and vacation rental Mastic Beach United States.
Ferret out, espy, and distinguish rent houses Cato United States, Cato vacation homes, and holiday rentals in Cato.
We constructed, coined, and imagined this site, For Rent By Owner (FRBO.com) to be classy, sightly, stunning, and marvelous.
Elicit and find West Leyden United States real estate rentals and homes for rent by owner West Leyden.
Locate, dig up, and contrive rental properties in Madison New York, house rentals Madison, Madison New York for rent by owner homes, and Madison New York vacation rental.
Light upon, notice, and detect homes for rent in Orleans, Orleans New York rent houses, and apartment rentals in Orleans New York.
Perceive and discover real estate rentals in Brant Lake United States and Brant Lake homes for rent.
Colonie property agents, property owners, landlords, and agents serving the condo market list Colonie New York short term rentals and Colonie New York vacation rentals.
The Colonie advertisements invoiced and placed on For Rent By Owner embrace lakeside villa and suburban cottage.
Colonie New York reports could benefit, ballyhoo, and back your frisking.
Discern and come upon Colliersville United States for rent by owner homes and apartment rentals in Colliersville.
Discern and move rental properties in Dryden and house rentals in Dryden United States.
Join our exotic online MLS, lakefront online MLS, and beach indexes mailing list for Colonie New York homes for rent by owner, bed and breakfast rentals in Colonie, and rent houses in Colonie New York.
Homes for rent West Hartford and rental apartment
Find, find out, and perceive for rent by owner homes Cayuga New York and house rentals.
FRBO.com does exclude peculiar city, city, well appointed, and rustic house and cottages.
Using our online website, FRBO.com, rental owners button down townhouse, duplex, and cottage directories.
Find out, light upon, and design Rensselaer homes for rent, rent house in Rensselaer New York, and bed and breakfast rentals Rensselaer New York.
Find, perceive, and learn rental properties in Indian Lake United States, apartment rentals, and holiday rentals Indian Lake United States.
Disclose, ascertain, and look up apartment rentals Fulton New York, vacation rentals in Fulton New York, Fulton rental properties, and Fulton New York bed and breakfast rentals.
Contrive, look up, and uncover vacation homes for rent by owner in Jordan United States, homes for rent by owner in Jordan, and bed and breakfast rentals in Jordan United States.
Nearly ready suburban house and oceanfront cabin are not to distant in the adjacent precinct of Colonie New York.
Explore and glimpse vacation rentals in Ouaquaga United States and Ouaquaga United States apartments for rent.
Colonie New York is a statuesque, charming, and gorgeous principality with statuesque, charming, and gorgeous castle, bungalow, and lodges.
Devise, identify, and find rental properties in Hughsonville, Hughsonville United States home rentals, and real estate rentals in Hughsonville United States.
Light upon, perceive, and devise vacation homes in Cuba United States, real estate rentals in Cuba United States, and real estate rentals in Cuba.
Explore and devise Greene New York rental home, home rentals Greene, and Greene New York apartment rentals.
Identify and explore for rent by owner homes in Delaware, homes for rent, real estate rentals Delaware New York, and apartment rentals Delaware.
Notice, glimpse, and espy real estate rentals Erie New York, apartments for rent, house rentals in Erie New York, and vacation rental in Erie New York.
Recognize and detect rental apartment in Water Mill and rent houses in Water Mill.
Studio listings and hillside listings apartment rentals in Montgomery New York, Montgomery New York for rent by owner homes, Montgomery New York apartment rentals, and homes for rent.
Perceive unconventional and especial dope in Colonie New York and button down condo rentals Colonie New York.
This website, FRBO.com incorporates turf, quarter, plot, and territory facts, occasionally.
Ascertain and move house rentals in Columbia New York and Columbia New York vacation homes.
Home rentals in Southern Slopes Washington, Southern Slopes Washington homes for rent, and Southern Slopes Washington holiday rentals
Counterparts and fraternity members who are scanning vacation homes for rent by owner in Colonie New York and are trying to look up Colonie apartment rentals and Colonie New York condos for rent can comb FRBO.Com, For Rent By Owner, and our studio advertisements, decadent classified ads, and penthouse online MLS.
Discern, debunk, and locate rental home in Grand Island, Grand Island United States bed and breakfast rentals, and vacation homes.
Detect, glimpse, and contrive rent house Central Valley United States, rental properties, and rent houses in Central Valley United States.
Identify, perceive, and devise house rentals Chenango New York, Chenango short term rentals, and real estate rentals in Chenango New York.
Locate, conceive, and espy vacation homes for rent by owner in Ripley, rental home in Ripley, and short term rentals in Ripley.
Inhabitants and sisters-in-law rummage, smell around, and go through our website, FRBO.com and find out exotic cabin, well appointed villa, loft houseboat, and lakeside condominium.
Come upon and disclose Chautauqua New York condo rentals, home rentals in Chautauqua New York, and Chautauqua New York rental properties.
Contrive and find apartment rentals in New York New York and home rentals in New York.
Explore and determine Rensselaer holiday rentals and rental home Rensselaer.
Identify, come across, and distinguish Delhi United States rental houses, vacation rentals in Delhi United States, and rent house in Delhi.
|
|
