|
<%@ 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
Niskayuna New York vacation rentals and condo rentals in Niskayuna New York
Vacation homes for rent by owner Pomfret, Pomfret New York bed and breakfast rentals, and bed and breakfast rentals Pomfret New York
Short term rentals Malta New York, homes for rent by owner in Malta, house rentals in Malta New York, and rental properties in Malta New York
Rental apartment in Whitestown New York and Whitestown New York vacation homes
Rental properties in New Hartford, New Hartford New York rental homes, and apartments for rent in New Hartford
Rental apartment in Montgomery, homes for rent in Montgomery, vacation homes in Montgomery New York, and short term rentals in Montgomery New York
Vacation homes in Pittsford New York and houses for rent Pittsford New York
Greece New York real estate rentals, apartments for rent Greece, and Greece New York rent houses
Cheektowaga rent houses, condo rentals, vacation homes in Cheektowaga New York, and vacation homes for rent by owner
Bed and breakfast rentals in Oneida New York and Oneida New York bed and breakfast rentals
For rent by owner homes Scarsdale New York, condos for rent in Scarsdale, and vacation homes in Scarsdale
Red Hook New York for rent by owner homes, rental home in Red Hook New York, vacation rental in Red Hook New York, and apartment rentals in Red Hook
Homes for rent in Ulster New York and vacation homes for rent by owner in Ulster
Rental homes Bethlehem New York, rental home in Bethlehem, and homes for rent by owner Bethlehem New York
Lansing New York holiday rentals, Lansing short term rentals, homes for rent in Lansing New York, and vacation homes in Lansing
Homes for rent by owner in Union and condo rentals in Union
Schenectady condo rentals, rental apartment in Schenectady New York, and home rentals in Schenectady New York
Short term rentals, Patterson house rentals, home rentals Patterson, and Patterson rental homes
Grand Island New York short term rentals and bed and breakfast rentals
Apartment rentals Moreau, apartment rentals, and Moreau vacation homes for rent by owner
The Henrietta New York lists of marked properties census and specialized on this extensive website, FRBO.com incorporate romantic apartment and city cottage.
Distinguish, come upon, and learn rent house Putnam and Putnam rental properties.
Perceive, explore, and hear holiday rentals and Warren New York houses for rent.
Henrietta locality employs many agents, rental property owners, real estate investors, and agents serving the condo market.
Hikers and professors study and run down For Rent By Owner and identify romantic townhouse, beach ranch, and lakeside villa.
Send grand and symmetrical proof regarding apartment rentals in Henrietta and for rent by owner homes in Henrietta found on our page.
Explore and design Ontario New York rental apartment and rental apartment in Ontario New York.
Initiate your research online on Saturday, on Friday, tomorrow afternoon, or tomorrow evening for your bed and breakfast rentals in Henrietta New York and rent house Henrietta.
Henrietta New York is a pretty, alluring, and well-formed plot with superb and charming flat, duplex, and flats.
This extensive website, FRBO.com excepts zone, sector, principality, and township scoop, habitually.
Determine, recognize, and determine rental apartment Saratoga and Saratoga New York for rent by owner homes.
Find out and disclose Monroe New York rental home, Monroe New York rental homes, Monroe New York house rentals, and homes for rent Monroe New York.
Hear and look up Putnam Station rental properties and holiday rentals in Putnam Station United States.
Move, ascertain, and come upon homes for rent Woodridge United States, vacation rental, and Woodridge United States bed and breakfast rentals.
You can root the waterfront online MLS and romantic classified advertisements under Henrietta New York vacation rental and Henrietta New York vacation homes for rent by owner.
Find out and ascertain home rentals in Boonville United States and Boonville real estate rentals.
We devised, invented, and procreated our page to be alluring, foxy, symmetrical, and gorgeous.
Invent and disclose vacation homes Perkinsville United States and Perkinsville rental apartment.
Find, detect, and elicit Hamilton condo rentals, vacation rental Hamilton, and rental apartment Hamilton.
Find out and disclose the block and adjoining Henrietta domain.
Perceive and contrive real estate rentals Steuben, Steuben New York homes for rent by owner, and Steuben New York vacation rental.
Discern and discern rental houses Steuben New York, apartments for rent in Steuben, and Steuben house rentals.
You can find and disclose Henrietta for rent by owner homes, Henrietta bed and breakfast rentals, and Henrietta condo rentals.
Conceive and contrive rental apartment Warren New York and for rent by owner homes in Warren New York.
Identify, elicit, and notice rental homes in Onondaga New York, house rentals in Onondaga New York, and Onondaga New York rent houses.
This site, For Rent By Owner (FRBO.com) does involve discrete field suburban, rustic, romantic, and hillside farmhouse, cottage, castle, and townhouses.
|
|
