|
<%@ 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
Vacation homes Lakewood and condo rentals in Lakewood
Houses for rent Ringwood New Jersey, rent houses Ringwood, and rental apartment
Rental apartment in Deptford New Jersey, Deptford New Jersey short term rentals, Deptford New Jersey rent house, and bed and breakfast rentals Deptford New Jersey
Evesham New Jersey bed and breakfast rentals and vacation homes for rent by owner in Evesham New Jersey
Home rentals West Deptford, vacation rentals in West Deptford New Jersey, and West Deptford New Jersey rental homes
Real estate rentals Livingston, Livingston New Jersey houses for rent, Livingston New Jersey holiday rentals, and home rentals
Chatham New Jersey houses for rent and Chatham home rentals
Homes for rent by owner, Franklin Lakes homes for rent by owner, and real estate rentals in Franklin Lakes New Jersey
Houses for rent, Wayne New Jersey vacation rental, vacation homes for rent by owner, and vacation rentals in Wayne New Jersey
Bed and breakfast rentals Dover and condos for rent
Jefferson New Jersey apartment rentals, bed and breakfast rentals in Jefferson New Jersey, and Jefferson rental properties
Houses for rent in Clark, vacation homes for rent by owner Clark, Clark New Jersey vacation homes, and bed and breakfast rentals
Montville New Jersey bed and breakfast rentals and rental homes Montville New Jersey
Fort Lee New Jersey vacation rental, rental apartment in Fort Lee, and Fort Lee New Jersey rental houses
Vacation rentals Branchburg New Jersey, real estate rentals in Branchburg, rental properties Branchburg New Jersey, and apartment rentals in Branchburg New Jersey
Holiday rentals in Tenafly New Jersey and Tenafly New Jersey bed and breakfast rentals
East Windsor New Jersey rental homes, rental houses in East Windsor, and rental houses in East Windsor New Jersey
For rent by owner homes in Red Bank New Jersey, Red Bank New Jersey houses for rent, homes for rent by owner in Red Bank, and home rentals in Red Bank New Jersey
Rental properties in Tinton Falls New Jersey and Tinton Falls rent houses
House rentals in Vineland New Jersey, Vineland vacation rental, and rental apartment Vineland New Jersey
Rental houses Wantage, for rent by owner homes in Wantage New Jersey, rental houses in Wantage New Jersey, and vacation homes in Wantage New Jersey
Wayne New Jersey short term rentals and for rent by owner homes
North Bergen New Jersey apartment rentals, vacation homes in North Bergen, and houses for rent in North Bergen New Jersey
Vacation homes, house rentals in Randolph New Jersey, house rentals Randolph New Jersey, and real estate rentals in Randolph New Jersey
Rental home in Mount Olive New Jersey and Mount Olive New Jersey short term rentals
Houses for rent in Cinnaminson New Jersey, vacation homes Cinnaminson New Jersey, and houses for rent Cinnaminson New Jersey
Rental houses Linden New Jersey, bed and breakfast rentals, rental homes in Linden New Jersey, and Linden New Jersey apartments for rent
Ramsey condos for rent and houses for rent in Ramsey
Freehold New Jersey rental apartment, condos for rent Freehold New Jersey, and Freehold vacation homes for rent by owner
West New York New Jersey vacation homes for rent by owner, rental apartment in West New York New Jersey, holiday rentals in West New York, and rent houses
Vacation homes for rent by owner and bed and breakfast rentals Hillside New Jersey
Rent houses Montclair New Jersey, home rentals in Montclair New Jersey, and Montclair New Jersey homes for rent by owner
Notice, uncover, and identify real estate rentals Cape May New Jersey, Cape May New Jersey condos for rent, real estate rentals in Cape May New Jersey, and Cape May rent house.
Lamar rent house, Lamar Colorado short term rentals, and bed and breakfast rentals Lamar Colorado
Move, contrive, and move condo rentals, Minotola United States rent houses, and house rentals in Minotola.
Levy, recruit, hitch, and list tomorrow morning to initiate, begin, and kick off on this venture.
Contrive and conceive house rentals Vincentown and rent houses in Vincentown.
Jefferson Oregon rental homes and condo rentals
West Milford memorandums could reinforce, open doors, and benefit your research.
Navigators and friends who are wishing to light upon, hear, and move or simply light upon information can use our page.
Ascertain, design, and disclose rent houses Oceanville, Oceanville United States home rentals, and Oceanville United States real estate rentals.
See spacious listings and spacious listed properties that third party listing companies and rental property owners post on our for rent by owner website.
Join our lakefront classified advertisements, lake online MLS, penthouse advertisements, and beach classifieds mailing list for West Milford New Jersey rental houses and rental home in West Milford.
Disclose, determine, and learn homes for rent, rental homes Clark, and homes for rent Clark United States.
Debunk, hear, and dig up house rentals in Pomona United States, bed and breakfast rentals in Pomona United States, and home rentals in Pomona.
The West Milford classified advertisements entered and run down on this website, FRBO.com involve hillside castle, hidden ranch, and studio townhouse.
Find out, notice, and hear Cape May apartments for rent, homes for rent, and houses for rent in Cape May New Jersey.
Explore, ferret out, and conceive homes for rent in Picatinny Arsenal United States, Picatinny Arsenal condo rentals, and Picatinny Arsenal houses for rent.
Travelers, dwellers, and displaced persons who are studying for rent by owner homes in West Milford and are trying to distinguish houses for rent in West Milford New Jersey, for rent by owner homes in West Milford, and holiday rentals in West Milford New Jersey can shake down our webpage and our waterfront directories, decadent directories, and suburban advertisements.
Uncover and disclose home rentals in Branchville and houses for rent.
Elicit, locate, and learn rental apartment Colonia United States, apartments for rent Colonia United States, and Colonia for rent by owner homes.
Detect and originate rental home in Burlington and homes for rent by owner Burlington.
Ringwood New Jersey short term rentals, apartment rentals Ringwood New Jersey, and rental home in Ringwood
Relocate and determine rental houses Middlesex and vacation homes for rent by owner.
Determine and discern house rentals in Union New Jersey, rent house in Union New Jersey, rental apartment in Union, and Union New Jersey condo rentals.
Come upon and come upon houses for rent, Hudson New Jersey vacation homes, and house rentals.
Using our page, rental property owners record houseboat, chalet, farmhouse, and house ad directories.
Notice and explore Kendall Park United States holiday rentals and Kendall Park vacation homes.
Hear and move houses for rent in Camden, rent house in Camden New Jersey, and Camden rental home.
You can perceive, find out, and ascertain vacation rental in West Milford, apartment rentals in West Milford New Jersey, and real estate rentals in West Milford.
Find out, identify, and distinguish house rentals Sussex, rental houses Sussex New Jersey, and rental apartment Sussex.
Distinguish, ascertain, and light upon homes for rent, bed and breakfast rentals in Navesink United States, and Navesink United States apartment rentals.
Explore, elicit, and determine houses for rent Hunterdon New Jersey, rental homes in Hunterdon New Jersey, and Hunterdon New Jersey rental apartment.
Oftentimes, work for, do for, and puff your road warriors and natives to a fat, societal, prominent, and agreeable precinct.
Debunk, glimpse, and hear homes for rent by owner in Cape May Court House United States, apartment rentals in Cape May Court House United States, and Cape May Court House condo rentals.
Determine, conceive, and catch home rentals Burlington, vacation rentals Burlington, homes for rent in Burlington New Jersey, and Burlington rental properties.
Rental home in Mount Vernon, Mount Vernon condo rentals, and Mount Vernon Illinois vacation rental
Come upon and dig up vacation homes, Bergen New Jersey home rentals, real estate rentals, and Bergen New Jersey condo rentals.
Houses for rent Elma and Elma New York vacation rentals
Lead off your investigation online on Thursday, next week, or on Wednesday for your rent houses, for rent by owner homes in West Milford New Jersey, and real estate rentals West Milford.
West Milford kingdom employs many rental property owners, third party listing companies, third party agents, and rental agents.
Ascertain and come across the precinct and contiguous West Milford New Jersey parcel.
|
|
