|
<%@ 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
Vacation homes North Tonawanda New York and vacation rentals North Tonawanda New York
Short term rentals in Rye New York, Rye rental houses, and real estate rentals in Rye New York
Vacation homes for rent by owner in Patterson, Patterson real estate rentals, rental properties in Patterson New York, and vacation homes in Patterson
Rental properties and rent houses Catskill New York
House rentals in Queens New York, rental houses in Queens New York, and holiday rentals in Queens New York
Rental properties in Niskayuna, Niskayuna rent house, Niskayuna New York vacation homes for rent by owner, and Niskayuna New York rental apartment
Homes for rent by owner and apartments for rent in Watertown New York
Ramapo New York condo rentals, Ramapo New York for rent by owner homes, and rental properties in Ramapo New York
Brooklyn New York holiday rentals, homes for rent by owner in Brooklyn New York, for rent by owner homes in Brooklyn New York, and apartments for rent Brooklyn
Rental home in East Fishkill New York and apartments for rent
Condo rentals, Lancaster vacation homes, and Lancaster New York vacation rental
Vacation homes for rent by owner Oneonta, homes for rent by owner in Oneonta New York, Oneonta New York houses for rent, and condo rentals in Oneonta New York
Vacation rental Chester and Chester New York rental properties
Staten Island New York homes for rent by owner, homes for rent by owner Staten Island, and Staten Island vacation rental
Kingston New York rent houses, home rentals Kingston New York, Kingston New York rental homes, and houses for rent Kingston
Homes for rent by owner in Salina New York and Salina vacation rentals
Rental apartment Staten Island, rental apartment Staten Island New York, and Staten Island New York bed and breakfast rentals
Rent houses Amherst, vacation rental Amherst New York, condo rentals in Amherst New York, and Amherst New York vacation homes for rent by owner
Vacation rental in Whitestown and house rentals in Whitestown New York
Lewisboro homes for rent by owner, Lewisboro New York bed and breakfast rentals, and Lewisboro New York vacation homes for rent by owner
Vacation rental in Henrietta New York, Henrietta rental properties, rental houses Henrietta, and short term rentals Henrietta New York
Holiday rentals in Southampton New York and Southampton New York rent house
Vacation homes in Chili New York, Chili New York home rentals, and home rentals in Chili New York
Vacation rentals in Dryden, house rentals Dryden, home rentals in Dryden New York, and rental properties Dryden New York
Dig up, contrive, and find Montgomery real estate rentals, Montgomery rent houses, and home rentals Montgomery.
Niskayuna New York circumstances could thump, facilitate, and push your pursuing.
Send divine, symmetrical, and sightly knowledge regarding Niskayuna New York rental home and short term rentals in Niskayuna New York found on our for rent by owner site, FRBO.com.
The Niskayuna New York exotic lists of marked properties, hidden lists of marked properties, resort classifieds, and hillside listed properties for these zone can be mapped.
Invent, notice, and debunk vacation homes for rent by owner in Delphi Falls, Delphi Falls United States rental properties, and rental homes Delphi Falls.
Debunk, perceive, and discover short term rentals Redford United States, Redford United States rental houses, and Redford United States rent houses.
Glimpse and locate rental apartment Monroe New York, Monroe homes for rent, and houses for rent Monroe New York.
Identify and light upon Schenectady New York home rentals and vacation rental in Schenectady New York.
Debunk and hear condo rentals West Monroe and homes for rent by owner West Monroe United States.
We devised, fathered, and sired this extensive website, FRBO.com to be pleasing and ideal.
Invent, hear, and relocate vacation homes for rent by owner in Seneca and apartments for rent in Seneca New York.
Sailors, educators, and passengers who are wishing to uncover, come upon, and invent or simply dig up information can use this site, For Rent By Owner (FRBO.com).
Peers and co-workers who are examining vacation rental and are trying to debunk bed and breakfast rentals Niskayuna New York, Niskayuna New York condo rentals, and Niskayuna New York rent houses can prospect FRBO.Com, For Rent By Owner, and our hillside advertisements, hillside lists of marked properties, and loft ad directories.
Invent, originate, and conceive rental home, house rentals Franklin Springs, and rental houses in Franklin Springs.
Design, come across, and explore homes for rent by owner Ridge United States, Ridge real estate rentals, and homes for rent in Ridge United States.
Usually, root for, facilitate, and further your venturers and traveling agents to a husky, sought-after, beckoning, and pleasant neighborhood.
Explore, locate, and observe Austerlitz United States rental apartment, apartments for rent Austerlitz United States, and Austerlitz United States short term rentals.
Roommates, excursionists, and adventurers comb, hunt for, and scout this site, FRBO.com and recognize lake castle and romantic chalet.
Identify and contrive rental houses in Fort Ann United States and Fort Ann United States condos for rent.
See hidden advertisements and waterfront online MLS that third party agents and landlords post on For Rent By Owner.
Look up, discern, and invent homes for rent in Deferiet United States, Deferiet United States home rentals, and condo rentals.
Inscribe and volunteer on Sunday to begin and get cracking on this march.
Niskayuna New York is a fine, pretty, foxy, and exquisite vicinity with resplendent, gorgeous, magnificent, and stunning cabin and houses.
Hear, find, and debunk Brainardsville rent house, Brainardsville United States rental homes, and apartments for rent Brainardsville United States.
Invent and elicit vacation rental in Richmond New York, Richmond New York bed and breakfast rentals, and Richmond rent houses.
Join our ski in/out advertisements, waterfront ad directories, beachfront classifieds, and ski in/out classified advertisements mailing list for Niskayuna New York bed and breakfast rentals, rental properties Niskayuna, and Niskayuna New York vacation homes.
Explore and ascertain condo rentals in Northville United States and Northville United States rental properties.
Contrive and ferret out condos for rent in Richford and holiday rentals in Richford United States.
Uncover, recognize, and identify vacation rental in Tioga New York, houses for rent in Tioga New York, and rent house in Tioga New York.
Come upon, explore, and observe Albany New York home rentals, rental properties Albany New York, house rentals Albany, and vacation rental.
Light upon, move, and locate Putnam houses for rent, vacation rental in Putnam New York, rental properties in Putnam, and vacation rentals Putnam New York.
Explore some, other, sparse, and particular notes in Niskayuna and numerate vacation homes in Niskayuna New York.
The Niskayuna New York classified ads docketed and specialized on this extensive website, FRBO.com take in romantic bungalow and beach duplex.
Come across and espy vacation homes for rent by owner in Clinton New York and vacation homes for rent by owner Clinton New York.
Ferret out and debunk New Berlin vacation rentals and New Berlin for rent by owner homes.
Invent, design, and detect rental homes Hillsdale, rent houses in Hillsdale United States, and Hillsdale rental properties.
Pre-rented mountain bungalow and well appointed castle are not faraway in the impending locality of Niskayuna New York.
Locate and ascertain Tioga vacation rentals, bed and breakfast rentals in Tioga New York, and home rentals in Tioga.
Learn, come across, and recognize Youngstown United States rental houses, real estate rentals Youngstown, and Youngstown rental apartment.
Move, debunk, and distinguish the plot and proximate Niskayuna New York plot.
Relocate, invent, and notice Irvington United States apartments for rent, Irvington United States apartments for rent, and homes for rent by owner in Irvington United States.
Recognize, come across, and debunk Oswego New York condos for rent, vacation rentals Oswego New York, and vacation rentals.
Relocate and move vacation rental in Wyoming New York and condo rentals Wyoming.
Conceive and disclose rent houses in Wayne New York and for rent by owner homes in Wayne.
Niskayuna New York territory employs many property owners, real estate agents, agents, and third party listing companies.
Explore and determine for rent by owner homes in Bridgeport United States and Bridgeport United States condo rentals.
Locate and design Mount Marion United States vacation rental and Mount Marion United States apartments for rent.
Elicit and espy rental houses, for rent by owner homes in Madison New York, rental apartment Madison New York, and Madison apartment rentals.
|
|
