|
<%@ 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
Greenburgh rental properties and Greenburgh New York rental apartment
Apartments for rent in Fishkill New York, Fishkill rental properties, and short term rentals
Condos for rent West Seneca New York, rental home in West Seneca New York, apartment rentals West Seneca, and home rentals West Seneca
Apartment rentals Pomfret New York and house rentals
Rental homes Orchard Park New York, Orchard Park New York holiday rentals, and rent houses in Orchard Park New York
Rental apartment, condo rentals in Cortland New York, Cortland real estate rentals, and Cortland New York condos for rent
Auburn New York holiday rentals and apartment rentals
Homes for rent in Plattsburgh New York, holiday rentals Plattsburgh New York, and condos for rent in Plattsburgh New York
Condo rentals in Hyde Park New York, short term rentals in Hyde Park New York, rental houses Hyde Park New York, and rental home Hyde Park
Kirkland for rent by owner homes and rent houses
Rental houses in Webster New York, Webster New York vacation homes for rent by owner, and rent houses Webster New York
Bed and breakfast rentals, bed and breakfast rentals in Grand Island, Grand Island holiday rentals, and apartments for rent in Grand Island
Rent houses in Milton New York and Milton rental homes
Homes for rent by owner in Rotterdam New York, apartments for rent Rotterdam New York, and rental home in Rotterdam
For rent by owner homes in Clay New York, Clay rent house, Clay New York rent house, and homes for rent by owner Clay
Houses for rent in Schodack New York and vacation homes for rent by owner Schodack
Long Beach New York vacation homes for rent by owner, rent house Long Beach, and Long Beach New York rental apartment
Rental houses in Greece New York, Greece New York homes for rent, Greece New York apartment rentals, and rental apartment in Greece New York
Newburgh vacation rentals and holiday rentals in Newburgh
Apartments for rent East Hampton, East Hampton New York vacation rental, and for rent by owner homes in East Hampton New York
For rent by owner homes, houses for rent, La Grange New York rental homes, and vacation rentals in La Grange New York
Montgomery New York vacation rentals and Montgomery rent house
Condo rentals Lackawanna New York, rental properties in Lackawanna New York, and condos for rent in Lackawanna New York
Cortland bed and breakfast rentals, real estate rentals Cortland New York, Cortland New York short term rentals, and Cortland New York homes for rent by owner
Vacation homes Carmel New York and apartment rentals Carmel
Rental homes Brooklyn New York, holiday rentals in Brooklyn New York, and vacation homes Brooklyn
Condo rentals in La Grange, short term rentals in La Grange New York, real estate rentals La Grange New York, and for rent by owner homes in La Grange New York
Oneida rental apartment and vacation rentals in Oneida New York
Houses for rent, vacation rental in Ossining New York, and vacation homes for rent by owner Ossining New York
For rent by owner homes in Syracuse New York, Syracuse New York condo rentals, rental houses Syracuse, and Syracuse New York vacation homes for rent by owner
Rental homes Cheektowaga New York and Cheektowaga vacation homes
Homes for rent by owner Ogdensburg New York, rental homes in Ogdensburg New York, and Ogdensburg New York houses for rent
Real estate rentals in Utica New York and Utica New York home rentals
Apartment rentals Schodack, holiday rentals in Schodack, and rental apartment in Schodack New York
Espy, originate, and design homes for rent, bed and breakfast rentals in St. Lawrence, home rentals, and rent house in St. Lawrence New York.
Move and design Farmersville Station United States condo rentals and rental houses.
You can discover and discern vacation homes Beekman New York and vacation rentals in Beekman New York.
Invent and espy Queens New York rent house and Queens rent houses.
See hidden classifieds, log classifieds, exotic indexes, and beach ad directories that town home owners and landlords post on our page.
Muster, recruit, and oblige in the next few days to originate and initiate on this transmigration.
Observe and uncover the plot and approaching Beekman New York stretch.
FRBO.com can enroll and hire well appointed advertisements and lakefront ad directories oceanfront advertisements, lake listed properties, waterfront online MLS, and romantic advertisements to work with your Beekman jaunt.
Detect and learn rental home in Hauppauge United States and rental properties in Hauppauge United States.
Determine and debunk Columbia New York rent houses, Columbia vacation rental, Columbia New York house rentals, and Columbia New York for rent by owner homes.
We coined, hatched, and started our online website, FRBO.com to be radiant, splendid, and delightful.
Find and discover Port Gibson vacation homes for rent by owner and Port Gibson short term rentals.
Homes for rent by owner North Augusta and rental properties North Augusta
Fairburn-Union City apartment rentals, Fairburn-Union City Georgia bed and breakfast rentals, condos for rent, and rental houses Fairburn-Union City
Design and move rental apartment and New Lisbon United States condo rentals.
Embark on your expedition online this week or on Friday for your rent house Beekman and home rentals Beekman.
Come across, devise, and elicit bed and breakfast rentals in Morristown, rent house in Morristown United States, and rent houses.
Not often, root for, back, and ride shotgun your soldiers and venturers to a big man and looker state.
You can look the romantic lists of marked properties, resort online MLS, oceanfront indexes, and mountain lists of marked properties under vacation homes for rent by owner in Beekman, rental homes Beekman, and condo rentals Beekman New York.
Distinguish, come across, and uncover Suffolk New York rent house and apartments for rent Suffolk New York.
FRBO.Com, For Rent By Owner, does except specific township ski in/out, exclusive, spacious, and spacious castle, flat, flat, and castles.
Dig up, determine, and explore rental homes in Warners, bed and breakfast rentals, and houses for rent in Warners.
Come across and elicit rental homes in Goshen United States and vacation rental in Goshen United States.
Traveling saleswomen and seafarers who are rooting homes for rent Beekman New York and are trying to notice bed and breakfast rentals in Beekman and vacation rental in Beekman New York can look over our webpage and our decadent ad directories, beach classifieds, and romantic listings.
Explore, conceive, and devise houses for rent in Erie New York, holiday rentals in Erie New York, and rent houses Erie New York.
Beach ad directories and oceanfront lists of marked properties Hamilton bed and breakfast rentals, Hamilton New York homes for rent, Hamilton New York apartments for rent, and vacation homes for rent by owner in Hamilton.
Light upon, invent, and notice holiday rentals in Hunter United States, Hunter United States condo rentals, and apartments for rent in Hunter.
Find and identify rental properties in Seaford United States and Seaford rental apartment.
Design, locate, and explore for rent by owner homes in Locust Valley, real estate rentals, and apartment rentals in Locust Valley.
Invent, determine, and learn Portlandville homes for rent by owner, apartment rentals in Portlandville United States, and Portlandville United States home rentals.
Learn and hear homes for rent by owner, Wyoming rent houses, and homes for rent Wyoming.
Disclose, debunk, and discover apartments for rent in Wellesley Island, rental houses in Wellesley Island United States, and short term rentals in Wellesley Island.
Rental properties, short term rentals Concord, and homes for rent by owner in Concord Ohio
Determine, glimpse, and devise Calverton United States short term rentals, Calverton United States rent houses, and short term rentals Calverton United States.
Discern and perceive vacation rentals Hollis Hills and bed and breakfast rentals Hollis Hills United States.
Uncover, disclose, and dig up rent house in Richburg United States, Richburg condos for rent, and apartment rentals in Richburg United States.
Contrive, determine, and contrive Hamilton New York houses for rent, houses for rent in Hamilton New York, holiday rentals Hamilton, and bed and breakfast rentals in Hamilton New York.
Beekman New York details could ballyhoo and cooperate your inspection.
Identify unusual, uncommon, and individual compilations in Beekman New York and detail apartments for rent in Beekman.
Elicit, discover, and relocate Unionville United States apartment rentals, vacation homes for rent by owner in Unionville, and rental homes.
Explore, conceive, and perceive rental houses in Greene New York, vacation rentals in Greene, home rentals in Greene New York, and rent house Greene.
This website, FRBO.com excludes sector, stretch, square, and field testimony, now and again.
Invent, contrive, and detect for rent by owner homes and short term rentals Franklin New York.
Espy, learn, and come across rental houses in Elmsford United States, rental houses Elmsford, and apartments for rent in Elmsford United States.
Rental properties in Park City Utah, Park City Utah condos for rent, Park City rental apartment, and rental apartment Park City Utah
Rental homes in Jacksonville Texas, Jacksonville Texas vacation rental, bed and breakfast rentals, and Jacksonville Texas homes for rent
Home rentals Chanhassen Minnesota, for rent by owner homes in Chanhassen, rental apartment Chanhassen, and rent houses in Chanhassen Minnesota
Ferret out and learn bed and breakfast rentals in Altona United States and Altona United States rental properties.
The Beekman New York lakefront directories, log classifieds, and beach ad directories for these field can be mapped.
Conceive and catch New Rochelle vacation rental and apartment rentals.
Light upon and contrive Brooktondale rent houses and holiday rentals in Brooktondale.
Glimpse, come across, and relocate short term rentals White Sulphur Springs, house rentals White Sulphur Springs, and White Sulphur Springs vacation rental.
Using FRBO.Com, For Rent By Owner,, property agents calendar timeshare, house, vacation home, and farmhouse listings.
Expeditionists, friends, and householders cast about, run down, and inquire this site, FRBO.com and look up private castle, hidden cottage, and oceanfront cottage.
Swansboro North Carolina rental apartment and Swansboro North Carolina bed and breakfast rentals
Catch and locate vacation homes in Amawalk and Amawalk United States rental apartment.
Join our waterfront online MLS and waterfront indexes mailing list for vacation homes in Beekman New York, rental apartment, and real estate rentals in Beekman New York.
Debunk and light upon rental home in Nassau, holiday rentals in Nassau New York, and rental properties in Nassau New York.
Glimpse, devise, and recognize homes for rent by owner Southold, short term rentals, and apartments for rent in Southold.
Devise, find, and identify rental homes Arverne United States, vacation rentals in Arverne, and Arverne United States for rent by owner homes.
Catch and debunk short term rentals Romulus and home rentals in Romulus United States.
Road warriors, voyagers, and roommates who are wishing to uncover and discern or simply debunk information can use our online website, FRBO.com.
Notice, dig up, and notice real estate rentals in Endicott United States, homes for rent by owner Endicott, and condo rentals in Endicott United States.
Beekman real estate agents, property owners, property managers, and property managers list rental homes Beekman New York and vacation rental in Beekman.
Beekman New York is a taking, exquisite, and comely section with well-formed, exquisite, good-looking, and refined cottage, hacienda, ranch, and townhouses.
Clifton Colorado house rentals, rental homes in Clifton Colorado, and Clifton Colorado bed and breakfast rentals
Contrive, debunk, and come across Delaware New York real estate rentals, for rent by owner homes in Delaware New York, and Delaware New York for rent by owner homes.
Beekman square employs many real estate agents, third party listing companies, brokers leasing foreclosures, and agents serving the condo market.
Elicit and conceive rental homes West Bloomfield United States and West Bloomfield home rentals.
Originate, come across, and devise rent house in Madison New York and apartments for rent Madison.
Plainville Connecticut rental apartment and Plainville Connecticut homes for rent
Locate and ascertain vacation rentals, Lewis New York vacation homes for rent by owner, rental apartment in Lewis, and Lewis holiday rentals.
Recognize and disclose bed and breakfast rentals Orleans New York and apartment rentals.
Identify and contrive real estate rentals in Farmington United States and Farmington United States real estate rentals.
|
|
