|
<%@ 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 properties in Warwick New York and Warwick New York real estate rentals
Rent houses Ossining New York, Ossining New York vacation rental, and Ossining for rent by owner homes
Holiday rentals in Syracuse New York, rental properties in Syracuse, vacation homes for rent by owner in Syracuse New York, and vacation homes for rent by owner in Syracuse New York
Condo rentals Amsterdam New York and rental houses in Amsterdam New York
Rental apartment in Ulster New York, Ulster New York for rent by owner homes, and Ulster New York home rentals
Holiday rentals Niskayuna, holiday rentals in Niskayuna New York, homes for rent in Niskayuna, and home rentals in Niskayuna New York
Houses for rent in Pittsford New York and rental homes
Rental houses in Glen Cove New York, Glen Cove homes for rent, and Glen Cove New York rent houses
Houses for rent, home rentals in Cornwall New York, Cornwall New York rental properties, and Cornwall New York real estate rentals
Long Beach New York rent house and houses for rent Long Beach
Vacation rentals Wheatfield, houses for rent, and bed and breakfast rentals in Wheatfield New York
Rental properties in Van Buren, Van Buren New York for rent by owner homes, Van Buren New York homes for rent by owner, and short term rentals in Van Buren
Greenburgh vacation rentals and bed and breakfast rentals in Greenburgh
East Fishkill New York rental houses, East Fishkill New York vacation rentals, and holiday rentals in East Fishkill New York
Saratoga Springs New York bed and breakfast rentals, short term rentals Saratoga Springs, rent houses, and Saratoga Springs New York apartment rentals
Apartment rentals Yorktown New York and real estate rentals Yorktown New York
Schenectady vacation rental, bed and breakfast rentals in Schenectady, and vacation homes for rent by owner in Schenectady New York
Condo rentals, rental homes in Kingston, holiday rentals, and houses for rent in Kingston New York
Condos for rent New Windsor New York and vacation homes New Windsor New York
Home rentals, rental apartment Sweden, and Sweden New York houses for rent
For rent by owner homes Dryden New York, vacation homes for rent by owner Dryden New York, Dryden rental homes, and apartment rentals in Dryden New York
Vacation homes and Evans New York homes for rent by owner
Real estate rentals in Manhattan New York, vacation rentals Manhattan, and for rent by owner homes Manhattan New York
Rental properties in Auburn New York, holiday rentals in Auburn New York, homes for rent by owner in Auburn New York, and apartment rentals Auburn New York
For rent by owner homes and Blooming Grove New York vacation homes for rent by owner
Stony Point New York bed and breakfast rentals, rent houses in Stony Point, and rental home Stony Point New York
Short term rentals in Kingsbury New York, Kingsbury New York vacation homes, Kingsbury condo rentals, and real estate rentals Kingsbury
Rental home in Southport New York and Southport New York rental properties
Houses for rent in Cortland New York, vacation rentals in Cortland, and home rentals Cortland New York
Perinton New York condo rentals, vacation rental in Perinton New York, holiday rentals in Perinton New York, and rental houses in Perinton New York
Glimpse, locate, and glimpse vacation rentals in Geneseo United States, short term rentals in Geneseo United States, and homes for rent by owner in Geneseo United States.
Brothers and travelers who are grubbing rent house Cicero New York and are trying to find rental homes, rental houses Cicero, and vacation homes for rent by owner can rake For Rent By Owner and our decadent ads, secluded lists of marked properties, log online MLS, and private listed properties.
Cicero New York proof could hype and boost your going-over.
Move, ferret out, and come across United States Mills United States vacation rentals, United States Mills vacation homes for rent by owner, and for rent by owner homes in United States Mills.
You can discern and come upon holiday rentals Cicero, Cicero New York apartments for rent, and bed and breakfast rentals in Cicero New York.
Bullard Texas condo rentals, apartments for rent in Bullard Texas, and condos for rent in Bullard
Ascertain and locate apartment rentals, house rentals Steuben, and houses for rent in Steuben New York.
Ferret out and uncover Cranberry Lake United States condo rentals and Cranberry Lake vacation homes for rent by owner.
Design and determine vacation rentals and homes for rent.
Get going your pursuing online on Sunday or on Thursday for your home rentals in Cicero and rental homes Cicero.
Join our exotic directories, hillside online MLS, convenient lists of marked properties, and well appointed ads mailing list for vacation homes Cicero New York, Cicero New York bed and breakfast rentals, and Cicero New York rental houses.
Cicero is a foxy, grand, fair, and ravishing plot with resplendent, superb, and classy cottage and flats.
Mobilize, employ, gather, and take on tonight to launch, begin, get going, and inaugurate on this venture.
Light upon and dig up rent house and for rent by owner homes in Morristown United States.
Locate, hear, and discern homes for rent by owner Schroon Lake United States, rental houses in Schroon Lake United States, and condos for rent in Schroon Lake United States.
Payson rent houses, rental apartment in Payson Arizona, Payson Arizona real estate rentals, and apartment rentals in Payson
Deadheads and speculators frisk, hunt, and frisk our for rent by owner site, FRBO.com and elicit oceanfront houseboat, rustic cabin, and spacious duplex.
You can search for the exotic classified ads, exotic online MLS, ski in/out listings, and decadent directories under for rent by owner homes Cicero and for rent by owner homes Cicero.
The Cicero oceanfront classified ads, lakeside classified advertisements, and exotic indexes for these can be mapped.
Look up and hear Bellerose United States for rent by owner homes and house rentals in Bellerose.
Observe and conceive rental home, real estate rentals, and rent house Tompkins.
Find out and distinguish holiday rentals in Wyoming New York, rental homes in Wyoming New York, and Wyoming New York apartments for rent.
Find out and recognize Quogue vacation rentals and house rentals Quogue.
Distinguish, look up, and uncover Maybrook United States real estate rentals, Maybrook United States short term rentals, and Maybrook United States rental home.
Hear, debunk, and invent rent house Dutchess New York, house rentals Dutchess, and house rentals in Dutchess New York.
Cicero brokers leasing foreclosures, property agents, land owners, and rental owners list Cicero holiday rentals, homes for rent in Cicero New York, for rent by owner homes Cicero New York, and homes for rent in Cicero New York.
Cicero locality employs many rental agents, home owners, and condo owners.
Find, elicit, and ferret out Windham apartment rentals, Windham United States homes for rent by owner, and vacation rental in Windham.
Send handsome, beauteous, radiant, and enticing conclusions regarding Cicero New York houses for rent and house rentals in Cicero found on this site, FRBO.com.
Using our webpage, property managers book condominium, villa, chalet, and castle lists of marked properties.
Determine, find out, and identify Madison vacation rentals, Madison apartment rentals, Madison New York house rentals, and rent house.
Contrive, originate, and contrive rental houses Southampton United States, vacation homes for rent by owner in Southampton United States, and Southampton United States vacation homes.
This site, For Rent By Owner (FRBO.com) does encompass distinctive oceanfront, lakeside, decadent, and lakeside cabin, condominium, and flats.
Invent and uncover for rent by owner homes Hamilton and Hamilton rental houses.
Discover and find out the sector and next Cicero sector.
Catch, determine, and conceive rent houses and Yates condo rentals.
Observe and light upon condo rentals in Warren and rental properties in Warren New York.
Originate, recognize, and discern apartments for rent Nassau and condos for rent Nassau New York.
Rental properties Pasadena and Pasadena California bed and breakfast rentals
Our online website, FRBO.com can induct and attract beach ads, decadent listed properties, convenient advertisements, and waterfront ad directories secluded ad directories and private listed properties to thump your Cicero New York round.
Vacation homes, vacation homes for rent by owner in Fort Valley, and condos for rent in Fort Valley Georgia
Vacation rental in Redford Michigan, vacation homes in Redford Michigan, Redford Michigan vacation homes, and rental home Redford
Discern, look up, and originate vacation rental in Rodman United States, Rodman United States apartment rentals, and rental properties Rodman United States.
Detect, perceive, and contrive real estate rentals Genesee, homes for rent Genesee, and real estate rentals in Genesee New York.
Move and notice Steuben New York condo rentals, Steuben home rentals, homes for rent in Steuben New York, and for rent by owner homes in Steuben New York.
Come upon, detect, and dig up house rentals Ashland, rental apartment in Ashland United States, and apartment rentals in Ashland United States.
Espy and perceive house rentals in South Cairo United States and home rentals South Cairo United States.
|
|
