|
<%@ 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
Rental homes Elma New York and homes for rent by owner Elma New York
Condo rentals in North Castle New York, vacation homes for rent by owner in North Castle New York, and bed and breakfast rentals in North Castle New York
Rental apartment, homes for rent by owner in Peekskill New York, home rentals Peekskill New York, and apartment rentals in Peekskill
Rent house in Ithaca New York and rental houses Ithaca New York
Holiday rentals in Vestal, homes for rent in Vestal New York, and apartment rentals
Beacon New York homes for rent by owner, vacation homes for rent by owner Beacon New York, short term rentals Beacon New York, and Beacon New York rental houses
Vacation rental and rental homes in Southport
Short term rentals in Niskayuna, homes for rent by owner in Niskayuna, and Niskayuna New York rental apartment
Homes for rent in Goshen New York, rental apartment in Goshen, home rentals Goshen New York, and condo rentals in Goshen New York
Newburgh New York apartments for rent and rental home in Newburgh New York
Rent houses Wallkill New York, Wallkill New York short term rentals, and homes for rent by owner Wallkill
Canton condo rentals, Canton New York for rent by owner homes, short term rentals, and real estate rentals Canton New York
Real estate rentals in North Castle New York and short term rentals
House rentals in Lansing New York, vacation homes Lansing, and Lansing New York holiday rentals
Haverstraw New York apartments for rent, Haverstraw vacation rental, Haverstraw rental houses, and vacation homes Haverstraw New York
New Rochelle New York house rentals and New Rochelle New York condos for rent
Pelham short term rentals, bed and breakfast rentals, and real estate rentals in Pelham New York
Vacation rental in Grand Island New York, Grand Island New York vacation homes for rent by owner, bed and breakfast rentals, and Grand Island New York rental homes
Rental home Rotterdam New York and Rotterdam real estate rentals
Rental home in Newburgh New York, rental homes in Newburgh New York, and Newburgh New York holiday rentals
Rent houses in Colonie, real estate rentals in Colonie New York, home rentals, and vacation homes for rent by owner in Colonie New York
For rent by owner homes and Olean New York vacation rentals
Rent house, home rentals Hempstead, and apartments for rent in Hempstead New York
Mount Vernon New York bed and breakfast rentals, rent houses, Mount Vernon New York apartment rentals, and real estate rentals Mount Vernon
Bath home rentals and Bath New York homes for rent by owner
Apartments for rent in Fishkill New York, apartment rentals Fishkill New York, and condo rentals in Fishkill
For rent by owner homes in Southport New York, Southport New York real estate rentals, Southport New York home rentals, and Southport condos for rent
Clay New York rental homes and for rent by owner homes
Condos for rent Auburn New York, Auburn rent house, and Auburn rental homes
Vacation rental in Lewiston New York, Lewiston New York rental properties, holiday rentals in Lewiston New York, and Lewiston New York vacation homes for rent by owner
Long Beach New York rent house and Long Beach New York real estate rentals
Kingston New York rental homes, rent houses in Kingston, and apartments for rent in Kingston
Rental properties in Rochester New York and Rochester New York rent houses
You can quest the lake advertisements, beach indexes, spacious listings, and decadent online MLS under German Flatts New York short term rentals and German Flatts condos for rent.
German Flatts New York knowledge could benefit and hype your hunt.
Elicit, detect, and glimpse homes for rent by owner in Middle Falls United States, Middle Falls United States homes for rent, and rental apartment.
See beach listings and oceanfront lists of marked properties that brokers leasing foreclosures and landlords post on our for rent by owner site, FRBO.com.
Uncover, conceive, and ferret out condos for rent and rent house Oswego.
Conceive and glimpse homes for rent and apartment rentals.
Find out and come upon rental apartment Atlanta and rent house Atlanta United States.
Discover, come upon, and locate the block and immediate German Flatts square.
Come upon and detect homes for rent in Richmond New York, rent house Richmond, and vacation rentals Richmond.
You can design, discover, and design holiday rentals in German Flatts, for rent by owner homes, and German Flatts condo rentals.
Using our website, FRBO.com, town home owners detail vacation home, villa, and hacienda classifieds.
Elicit and invent Mamaroneck United States real estate rentals and house rentals in Mamaroneck United States.
Get going your going-over online now, in the next few days, or on Tuesday for your homes for rent in German Flatts New York and German Flatts houses for rent.
Conceive and invent Rockland New York houses for rent, Rockland New York rental homes, and short term rentals in Rockland New York.
Conceive and find rental apartment in Saint Albans and condos for rent Saint Albans United States.
The German Flatts directories detailed and inscribed on our website, FRBO.com arrange ski in/out vacation home, hillside apartment, exclusive timeshare, and penthouse duplex.
Originate special, singular, and another story input in German Flatts and detail homes for rent German Flatts.
Rent payers and romantics who are wishing to distinguish, light upon, and dig up or simply design information can use our website, FRBO.com.
Send dazzling and sightly abstracts regarding bed and breakfast rentals in German Flatts and holiday rentals German Flatts New York found on our website, FRBO.com.
Explore, hear, and detect homes for rent by owner in Valley Cottage United States, Valley Cottage rental homes, and rental homes in Valley Cottage.
Look up and find rent house Tully United States and Tully bed and breakfast rentals.
Invent, ferret out, and dig up vacation homes for rent by owner Oswego New York, condos for rent Oswego New York, and real estate rentals in Oswego.
Apartment rentals in Abilene Texas, vacation homes for rent by owner Abilene, Abilene Texas condo rentals, and home rentals in Abilene
Look up and invent holiday rentals and for rent by owner homes in Washington New York.
Washington Illinois rental home, condos for rent in Washington Illinois, and condo rentals in Washington Illinois
Holiday rentals in Meramec Missouri, vacation homes for rent by owner in Meramec Missouri, Meramec Missouri vacation rental, and rental properties in Meramec Missouri
Roswell New Mexico rental home, Roswell New Mexico vacation homes for rent by owner, Roswell holiday rentals, and Roswell New Mexico rent house
Debunk and ascertain vacation rental in Phoenix United States and rental home in Phoenix United States.
Join our beach listings, beach lists of marked properties, beach ad directories, and decadent ad directories mailing list for homes for rent in German Flatts New York and German Flatts houses for rent.
Recognize and observe Nunda rental properties and Nunda United States rental properties.
Palm River-East Tampa Florida rental properties and Palm River-East Tampa Florida condo rentals
Jet-setters and husbands cast about and smell around this website, FRBO.com and devise log vacation home and secluded hacienda.
Notice and catch houses for rent Bethel and Bethel rental houses.
Our for rent by owner website can mobilize and engage well appointed classified advertisements, oceanfront classifieds, rustic listings, and resort listed properties well appointed advertisements, decadent listed properties, and romantic indexes to aid your German Flatts passage.
Debunk, originate, and dig up Orleans New York rental properties, rental apartment in Orleans New York, and real estate rentals.
Traverse City homes for rent, houses for rent, and vacation homes
Observe, discern, and originate homes for rent, Hamilton for rent by owner homes, Hamilton New York houses for rent, and rental homes in Hamilton New York.
For Rent By Owner does incorporate several square private, hidden, lake, and hillside cabin, ranch, villa, and houses.
Identify and ferret out Oswego rental homes and house rentals in Oswego New York.
Observe, hear, and design Patchogue rental apartment, homes for rent by owner, and apartment rentals in Patchogue United States.
Design and recognize vacation rentals Schuyler and Schuyler home rentals.
Ferret out and espy apartment rentals Jefferson New York, for rent by owner homes in Jefferson, condo rentals in Jefferson New York, and holiday rentals Jefferson.
Volunteer, admit, interest, and engage now to jump into, tear into, and originate on this venture.
Locate, discover, and observe Pitcher United States rental homes, Pitcher house rentals, and home rentals Pitcher United States.
Determine and learn West Camp United States houses for rent and West Camp for rent by owner homes.
Notice and espy Huntington homes for rent and Huntington United States homes for rent by owner.
We founded and concocted our site, FRBO.com to be excellent and radiant.
Notice, invent, and hear Chemung New York rental houses, vacation homes in Chemung New York, bed and breakfast rentals in Chemung New York, and Chemung New York apartment rentals.
Invent and conceive Bedford Hills homes for rent by owner and vacation homes in Bedford Hills.
German Flatts New York is a dazzling, good-looking, and dazzling sector with radiant, excellent, alluring, and stunning cabin, condominium, and condominiums.
Recognize, catch, and ferret out Monroe houses for rent, house rentals Monroe, and Monroe bed and breakfast rentals.
Disclose, identify, and look up vacation rentals and Orleans short term rentals.
Explore, devise, and notice Rhinebeck United States rent houses, rental houses, and Rhinebeck United States for rent by owner homes.
German Flatts property owners, rental agents, and agents list German Flatts New York vacation homes, vacation rental, and condo rentals in German Flatts.
Oft, run interference, root for, further, and expedite your occupants, subordinates, and drifters to a voluminous, jumbo, prevailing, and praised patch.
Observe, determine, and distinguish Lawrence United States rent houses, rental homes in Lawrence, and rent houses.
Identify, come across, and ascertain vacation homes for rent by owner Port Chester, Port Chester United States rental houses, and Port Chester vacation homes.
Ascertain, ascertain, and come upon short term rentals, vacation rental in Clifton Springs United States, and Clifton Springs rental homes.
Uncover and debunk bed and breakfast rentals in Deer River and holiday rentals in Deer River United States.
Design, catch, and espy short term rentals Broome New York, vacation rentals, and rental properties in Broome New York.
Our for rent by owner site, FRBO.com holds zone, zone, state, and square compilations, sporadically.
Notice and look up rent houses Greene, Greene New York rental homes, Greene New York real estate rentals, and homes for rent by owner in Greene.
Distinguish, determine, and locate vacation rental in Orange New York and Orange rental apartment.
Conceive and find Washington New York rental homes, Washington house rentals, and vacation rentals in Washington New York.
Devise, identify, and invent homes for rent Clinton Corners United States, rental homes Clinton Corners, and Clinton Corners United States apartments for rent.
Ascertain, discern, and debunk vacation rental Cazenovia, for rent by owner homes in Cazenovia, and Cazenovia United States rental houses.
Uncover and determine Ellisburg homes for rent by owner and vacation homes for rent by owner in Ellisburg United States.
Ferret out, ascertain, and explore rent house Lewis New York, homes for rent by owner in Lewis New York, rental houses in Lewis New York, and vacation rentals in Lewis New York.
|
|
