|
<%@ 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 Jersey Rental Links
Home rentals Galloway and rent house
Rent house, Barnegat rental properties, and condo rentals in Barnegat
Rental homes Vernon, rental homes in Vernon New Jersey, vacation homes in Vernon New Jersey, and house rentals in Vernon New Jersey
Holiday rentals in Little Ferry New Jersey and rent house in Little Ferry New Jersey
Rent houses in Stafford New Jersey, vacation homes, and Stafford New Jersey vacation rental
Little Ferry New Jersey apartments for rent, Little Ferry vacation homes, rental properties in Little Ferry New Jersey, and Little Ferry bed and breakfast rentals
For rent by owner homes and Rahway New Jersey rental apartment
Houses for rent in West Windsor New Jersey, West Windsor short term rentals, and real estate rentals West Windsor New Jersey
Bed and breakfast rentals Manalapan, Manalapan houses for rent, Manalapan rent house, and homes for rent in Manalapan New Jersey
Vacation homes for rent by owner Saddle Brook and Saddle Brook homes for rent by owner
Rent houses Washington New Jersey, Washington New Jersey condo rentals, and house rentals in Washington New Jersey
Rental properties Moorestown New Jersey, vacation rentals Moorestown New Jersey, Moorestown New Jersey rental home, and houses for rent in Moorestown
Middletown New Jersey for rent by owner homes and Middletown New Jersey homes for rent
For rent by owner homes in Egg Harbor, apartment rentals in Egg Harbor New Jersey, and rental home in Egg Harbor
Hopewell New Jersey for rent by owner homes, Hopewell home rentals, rental homes, and Hopewell New Jersey rental homes
Rental apartment Clifton New Jersey and vacation homes Clifton New Jersey
Point Pleasant New Jersey real estate rentals, Point Pleasant rental houses, and Point Pleasant New Jersey rent house
Condo rentals in Union City New Jersey, house rentals, short term rentals in Union City New Jersey, and rent house in Union City New Jersey
Rent house and rental home in Hackettstown New Jersey
Homes for rent by owner in Moorestown New Jersey, houses for rent, and for rent by owner homes
Homes for rent by owner in Ringwood New Jersey, homes for rent by owner in Ringwood, Ringwood apartments for rent, and Ringwood New Jersey rental home
Homes for rent Edison and holiday rentals in Edison New Jersey
Vacation rental Denville, vacation homes for rent by owner, and rental properties Denville
Dover New Jersey vacation homes, rental houses in Dover New Jersey, Dover homes for rent by owner, and Dover New Jersey houses for rent
Holiday rentals and homes for rent Pequannock New Jersey
West Milford New Jersey vacation homes, West Milford New Jersey vacation rental, and West Milford rental apartment
Vacation homes Brigantine New Jersey, apartments for rent in Brigantine New Jersey, condo rentals Brigantine, and Brigantine short term rentals
Come across and invent Point Pleasant Beach United States vacation homes for rent by owner and for rent by owner homes in Point Pleasant Beach United States.
Originate and originate Gloucester New Jersey homes for rent by owner, Gloucester bed and breakfast rentals, vacation homes in Gloucester New Jersey, and short term rentals in Gloucester.
Invent and discover for rent by owner homes in Sussex New Jersey, Sussex New Jersey short term rentals, and holiday rentals in Sussex.
You can look up and espy rent houses in West Windsor and rent house in West Windsor.
Using this site, FRBO.com, agents specialize ranch, castle, hacienda, and cottage classified advertisements.
Find and learn condos for rent and real estate rentals Brookside.
Dig up, come upon, and come across short term rentals Atlantic New Jersey and holiday rentals.
Come upon and disclose apartment rentals in Somerset New Jersey and Somerset holiday rentals.
Explore and locate houses for rent in Mercer New Jersey and house rentals Mercer New Jersey.
Perceive, design, and devise rental home in Willingboro United States, short term rentals Willingboro, and Willingboro homes for rent by owner.
Glimpse and locate apartment rentals in Ocean New Jersey, rent house in Ocean New Jersey, and rental apartment.
Catch, identify, and ferret out Cape May New Jersey home rentals, apartment rentals, and for rent by owner homes.
Relocate, discover, and come across real estate rentals, Gibbsboro United States home rentals, and vacation rentals Gibbsboro.
Identify, identify, and observe home rentals Kearny, Kearny United States houses for rent, and apartments for rent in Kearny United States.
Devise and invent apartment rentals Shiloh and Shiloh United States rental houses.
Espy, recognize, and notice condos for rent in Middlesex, rental houses Middlesex, Middlesex real estate rentals, and rental home.
Short term rentals, homes for rent by owner in Russian River-Coastal California, Russian River-Coastal California vacation homes for rent by owner, and real estate rentals in Russian River-Coastal California
Arlington rental apartment, Arlington Washington homes for rent by owner, and vacation homes for rent by owner in Arlington
Notice, discern, and distinguish rent house in Hunterdon, homes for rent by owner Hunterdon New Jersey, bed and breakfast rentals Hunterdon New Jersey, and apartments for rent Hunterdon.
Dig up, contrive, and notice Park Ridge condos for rent, houses for rent, and Park Ridge United States vacation rentals.
Look up, conceive, and catch rental properties in Middlesex, homes for rent in Middlesex New Jersey, and short term rentals in Middlesex New Jersey.
Ferret out, design, and identify Burlington New Jersey condo rentals and house rentals in Burlington New Jersey.
You can inspect the hillside online MLS, penthouse listings, and spacious listings under rental properties in West Windsor New Jersey and West Windsor New Jersey holiday rentals.
Englewood Ohio rent house and condos for rent Englewood Ohio
West Windsor New Jersey is a shapely, gorgeous, resplendent, and fine vicinity with beauteous, sublime, and beauteous bungalow, house, flat, and apartments.
Ascertain, find, and ferret out apartments for rent in Warren, Warren New Jersey rental apartment, and condos for rent Warren New Jersey.
West Windsor New Jersey whole story could ballyhoo and support your fishing expedition.
Originate, locate, and light upon vacation homes, Middleville United States homes for rent, and bed and breakfast rentals.
For rent by owner homes in Marco Island, rental houses Marco Island, apartment rentals, and condos for rent Marco Island Florida
The West Windsor exotic classified ads, waterfront advertisements, romantic classified advertisements, and lakeside ad directories for these can be mapped.
Find out, observe, and look up the field and not faraway West Windsor New Jersey block.
Design, perceive, and contrive Salem rental properties and house rentals Salem New Jersey.
See ski in/out indexes and convenient directories that real estate investors and property brokers post on our for rent by owner website.
Lakefront listings and studio online MLS for rent by owner homes in Cumberland, apartment rentals in Cumberland New Jersey, Cumberland New Jersey vacation rental, and Cumberland New Jersey bed and breakfast rentals.
Look up and come across Farmingdale United States holiday rentals and rental houses Farmingdale United States.
Citizens, schoolmates, and colleagues check, run down, and probe this site, For Rent By Owner (FRBO.com) and identify romantic villa, romantic houseboat, and beach home.
Locate, design, and dig up rental apartment Budd Lake, vacation homes Budd Lake United States, and homes for rent by owner Budd Lake.
Come across, locate, and identify Stockholm United States apartments for rent, Stockholm United States home rentals, and Stockholm United States rental houses.
Enroll, embody, and call up tomorrow to launch, enter upon, initiate, and originate on this migration.
Discover, debunk, and distinguish condo rentals in Roosevelt, apartments for rent Roosevelt United States, and Roosevelt United States rent house.
Notice and relocate rental houses in Deepwater United States and homes for rent by owner Deepwater.
Debunk and observe condos for rent in Fortescue and holiday rentals Fortescue.
Jump into your inquest online this week, this week, tomorrow evening, or this evening for your house rentals in West Windsor New Jersey and West Windsor rental homes.
Recognize, detect, and discover vacation rentals Willingboro, Willingboro United States for rent by owner homes, and apartments for rent in Willingboro United States.
|
|
