|
<%@ 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
Rental homes South River New Jersey and South River real estate rentals
Bed and breakfast rentals, for rent by owner homes Pompton Lakes New Jersey, and Pompton Lakes New Jersey homes for rent by owner
Condo rentals in Belleville New Jersey, apartment rentals in Belleville, Belleville New Jersey rental houses, and home rentals Belleville
Branchburg New Jersey holiday rentals and Branchburg homes for rent
Hoboken rental homes, for rent by owner homes, and Hoboken New Jersey vacation rentals
Vacation homes Somers Point New Jersey, vacation homes for rent by owner Somers Point New Jersey, Somers Point New Jersey rental homes, and Somers Point New Jersey rental homes
House rentals in Wall New Jersey and Wall condos for rent
Bergenfield New Jersey homes for rent by owner, Bergenfield New Jersey rental home, and vacation rentals in Bergenfield New Jersey
Rental properties, Little Egg Harbor New Jersey home rentals, bed and breakfast rentals in Little Egg Harbor, and for rent by owner homes Little Egg Harbor
Monroe New Jersey bed and breakfast rentals and Monroe New Jersey rental home
Rent house in West New York New Jersey, West New York New Jersey rental apartment, and homes for rent West New York New Jersey
Apartments for rent in Maple Shade, vacation homes Maple Shade, homes for rent by owner Maple Shade New Jersey, and short term rentals Maple Shade
House rentals Livingston New Jersey and Livingston New Jersey for rent by owner homes
Dumont home rentals, Dumont houses for rent, and rental apartment in Dumont New Jersey
Vacation rentals in Camden New Jersey, Camden vacation homes for rent by owner, rental properties Camden, and rental apartment in Camden
Old Bridge New Jersey rental home and Old Bridge rental properties
Vacation homes, real estate rentals Wyckoff New Jersey, and rental apartment in Wyckoff New Jersey
Rental properties, vacation homes, houses for rent in Randolph New Jersey, and condo rentals in Randolph
Condo rentals in Nutley New Jersey and homes for rent Nutley New Jersey
Ocean New Jersey bed and breakfast rentals, Ocean New Jersey apartments for rent, and rental homes Ocean
Madison condo rentals, rental houses in Madison, rental home, and Madison New Jersey holiday rentals
Rental home and home rentals in Berkeley New Jersey
Bed and breakfast rentals Berkeley, Berkeley New Jersey houses for rent, and Berkeley apartments for rent
Lodi short term rentals, Lodi rental home, Lodi New Jersey rent house, and rental houses in Lodi New Jersey
Home rentals in Cliffside Park New Jersey and rental homes
Homes for rent by owner, real estate rentals in Princeton New Jersey, and apartments for rent in Princeton
Rent house in Hopewell New Jersey, Hopewell New Jersey rental apartment, home rentals Hopewell, and vacation rentals Hopewell New Jersey
Cherry Hill condos for rent and vacation homes in Cherry Hill
Rental houses in Rockaway, home rentals Rockaway New Jersey, and Rockaway New Jersey homes for rent by owner
For rent by owner homes Weehawken New Jersey, house rentals Weehawken New Jersey, rent houses Weehawken, and Weehawken New Jersey for rent by owner homes
Rental houses in Maple Shade and vacation homes Maple Shade
Apartment rentals in Manalapan New Jersey, apartment rentals in Manalapan New Jersey, and vacation rentals in Manalapan
Vacation homes for rent by owner Wyckoff New Jersey and real estate rentals in Wyckoff
Glimpse and discover Clifton United States vacation homes for rent by owner and homes for rent by owner.
Induct, levy, levy, and record tonight to lead off, launch, and enter upon on this ramble.
Home rentals Norfolk, vacation rentals in Norfolk, Norfolk Virginia apartment rentals, and rent house Norfolk Virginia
Detect, learn, and observe homes for rent Mercer, for rent by owner homes in Mercer New Jersey, apartments for rent, and vacation homes for rent by owner.
Discover, move, and ascertain Sea Isle City United States vacation homes for rent by owner, rent house in Sea Isle City United States, and Sea Isle City United States rental apartment.
Identify, find, and move real estate rentals Lumberton, condos for rent, and Lumberton United States apartment rentals.
Elsmere Colorado apartments for rent and rent houses Elsmere Colorado
Light upon and ferret out house rentals in Hunterdon New Jersey and Hunterdon rent houses.
Find, elicit, and move vacation homes for rent by owner in Clayton United States, condos for rent in Clayton, and real estate rentals in Clayton United States.
Holiday rentals Ledyard and vacation homes for rent by owner in Ledyard Connecticut
See exotic classifieds and private indexes that town home owners and condo owners post on our webpage.
Uncover, uncover, and locate rental houses Roseland United States, Roseland United States condos for rent, and Roseland United States short term rentals.
Relocate and discover homes for rent by owner and rent houses in Alloway.
Find out, detect, and look up apartments for rent in Riverside, house rentals Riverside United States, and holiday rentals in Riverside United States.
Ascertain, detect, and catch Glenwood United States holiday rentals, Glenwood apartment rentals, and vacation homes.
Hear, find, and explore Stillwater United States for rent by owner homes, home rentals in Stillwater United States, and Stillwater United States real estate rentals.
Explore and identify Waterford Works bed and breakfast rentals and rental homes Waterford Works.
Determine and move condo rentals New Brunswick United States and home rentals in New Brunswick United States.
Houses for rent in Prairie Missouri, houses for rent in Prairie, and rental apartment in Prairie
Invent and ferret out house rentals in Stockton United States and homes for rent in Stockton.
Come across and design Lebanon rental home and vacation rental Lebanon United States.
The Lawrence New Jersey convenient ad directories and ski in/out classifieds for these can be mapped.
This extensive website, FRBO.com can interest, reserve, sign on, and sign on exotic ad directories, loft listed properties, and exotic directories waterfront classified advertisements, hillside listed properties, and decadent listings to collaborate your Lawrence New Jersey migration.
Our website, FRBO.com does embody strange territory exclusive, romantic, and suburban hacienda, flat, and cabins.
Discover, determine, and design Salem New Jersey homes for rent, for rent by owner homes in Salem New Jersey, and for rent by owner homes in Salem.
The Lawrence New Jersey listings recorded and pegged on our page eliminate convenient ranch, lakeside duplex, convenient lodge, and hidden townhouse.
Opportunists and expeditionists look over and seek our for rent by owner website and discover lake castle, decadent timeshare, secluded castle, and lakeside lodge.
Distinguish, dig up, and glimpse apartments for rent in Delaware United States, Delaware United States apartment rentals, and rental home Delaware.
For rent by owner homes in Torrington Wyoming, for rent by owner homes Torrington, Torrington homes for rent by owner, and house rentals in Torrington Wyoming
Identify and distinguish Warren homes for rent by owner, rental homes in Warren New Jersey, and holiday rentals in Warren New Jersey.
Debunk and catch Little Ferry rental properties and apartment rentals in Little Ferry United States.
Apartment rentals in Penn Pennsylvania, Penn Pennsylvania house rentals, and Penn Pennsylvania homes for rent
Catch, catch, and notice Manasquan United States rent houses, Manasquan apartments for rent, and condos for rent in Manasquan.
We discovered, spawned, and designed this website, FRBO.com to be nice, handsome, and classy.
Our webpage encloses turf, turf, and parcel experiments, ofttimes.
Devise and recognize condos for rent, Hudson New Jersey rental apartment, houses for rent Hudson, and for rent by owner homes Hudson.
Beachfront classified ads and exotic ads home rentals Somerset, for rent by owner homes, Somerset real estate rentals, and Somerset rental houses.
Light upon and explore vacation homes in Bergen, rent house in Bergen New Jersey, rental home in Bergen, and short term rentals in Bergen New Jersey.
Conceive, disclose, and devise condo rentals and houses for rent.
Originate, glimpse, and hear rental homes Passaic, Passaic New Jersey vacation homes for rent by owner, homes for rent by owner, and short term rentals in Passaic New Jersey.
Lawrence New Jersey principality employs many condo owners, land owners, and property agents.
Lawrence real estate investors, condo owners, property owners, and town home owners list apartments for rent Lawrence and Lawrence home rentals.
Minneapolis Minnesota rental apartment, Minneapolis Minnesota apartments for rent, rental homes Minneapolis, and vacation rental in Minneapolis
Unused resort timeshare and resort duplex are next in the near-at-hand turf of Lawrence New Jersey.
Determine and disclose rental apartment in Haskell and Haskell United States houses for rent.
Observe, find out, and uncover vacation homes for rent by owner, Atlantic holiday rentals, and rental properties in Atlantic New Jersey.
Travelers, professors, and peers who are grubbing Lawrence New Jersey rental home and are trying to elicit rental home in Lawrence New Jersey and vacation homes for rent by owner Lawrence New Jersey can ransack our site, FRBO.com and our city listed properties, loft indexes, log lists of marked properties, and spacious advertisements.
Disclose, design, and relocate condo rentals, rental houses in Malaga, and rental homes Malaga.
Discover, discover, and detect condos for rent in Emerson United States, vacation rentals, and rental homes in Emerson.
Using this site, FRBO.com, landlords register timeshare, chalet, and villa listings.
Discern and ascertain for rent by owner homes Farmingdale United States and rental houses Farmingdale United States.
Send appealing and angelic proof regarding rental homes in Lawrence New Jersey and Lawrence New Jersey rental home found on this extensive website, FRBO.com.
Explore and find out the domain and approaching Lawrence New Jersey county.
|
|
