|
<%@ 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
Bed and breakfast rentals and Vineland New Jersey rental homes
Rent houses in South River New Jersey, bed and breakfast rentals, and short term rentals
Homes for rent by owner, house rentals, homes for rent in Jersey City, and condo rentals in Jersey City New Jersey
Howell New Jersey bed and breakfast rentals and rental houses
Rent houses in Beachwood New Jersey, Beachwood New Jersey apartments for rent, and apartment rentals Beachwood New Jersey
For rent by owner homes Manchester, Manchester New Jersey rental apartment, Manchester New Jersey holiday rentals, and Manchester New Jersey homes for rent by owner
Vacation rental and Millburn rent houses
Hawthorne New Jersey condos for rent, houses for rent Hawthorne, and homes for rent Hawthorne
Rent house Deptford New Jersey, short term rentals in Deptford New Jersey, Deptford New Jersey condos for rent, and Deptford New Jersey rental houses
Rental houses Voorhees and Voorhees New Jersey condo rentals
Rental apartment in Trenton New Jersey, rental apartment in Trenton New Jersey, and vacation rentals Trenton
Real estate rentals, East Brunswick New Jersey homes for rent, apartments for rent in East Brunswick New Jersey, and rent houses East Brunswick New Jersey
Vacation rentals and Bloomfield New Jersey rental home
Apartment rentals Bridgeton New Jersey, Bridgeton New Jersey home rentals, and Bridgeton New Jersey rental apartment
Bergenfield home rentals, real estate rentals Bergenfield, rent houses in Bergenfield New Jersey, and Bergenfield New Jersey apartments for rent
Rental houses in Perth Amboy and vacation rental
Rental properties in Red Bank New Jersey, Red Bank New Jersey real estate rentals, and Red Bank apartment rentals
Home rentals Paramus, Paramus New Jersey homes for rent by owner, condo rentals in Paramus New Jersey, and short term rentals in Paramus New Jersey
You can debunk and locate rental apartment in Tenafly, house rentals Tenafly New Jersey, and real estate rentals in Tenafly.
Design, debunk, and catch short term rentals in Bergen, vacation rentals in Bergen, and condos for rent.
Catch and espy Franklin Lakes United States rent house and homes for rent in Franklin Lakes United States.
Catch, ascertain, and explore Dorchester United States homes for rent by owner, houses for rent in Dorchester, and short term rentals Dorchester United States.
Dig up uncommon and especial dossier in Tenafly New Jersey and run down houses for rent.
Join our resort classified advertisements and waterfront advertisements mailing list for home rentals Tenafly New Jersey and homes for rent by owner Tenafly.
Discover and design rental houses Sussex, Sussex New Jersey vacation homes for rent by owner, and vacation rentals Sussex.
Invent and locate short term rentals Hudson, rental homes Hudson, and Hudson New Jersey for rent by owner homes.
Tenafly real estate investors, agents, town home owners, and rental agents list Tenafly New Jersey real estate rentals and Tenafly rental home.
Disclose, recognize, and ferret out Monroeville United States rental home, rental home Monroeville United States, and vacation rentals in Monroeville United States.
Our for rent by owner site, FRBO.com can admit and hitch ski in/out listed properties, lakeside listings, and log lists of marked properties convenient listed properties and exclusive advertisements to support your Tenafly migration.
See log listings, spacious listings, secluded classified advertisements, and secluded classifieds that real estate investors and third party listing companies post on this webpage.
Originate and find condo rentals and real estate rentals Garwood United States.
Relocate and notice rental home in Fairton and home rentals.
Tenafly knowledge could cooperate, aid, and support your fishing expedition.
Relocate and ferret out apartment rentals in Atlantic New Jersey, condo rentals in Atlantic New Jersey, rent houses in Atlantic New Jersey, and Atlantic New Jersey homes for rent.
Debunk, observe, and ascertain Ocean New Jersey houses for rent and Ocean New Jersey rent house.
Get cracking your pursuing online this weekend, tomorrow morning, or on Monday for your rental properties Tenafly New Jersey, rental home Tenafly New Jersey, and vacation homes for rent by owner Tenafly.
The Tenafly classifieds run down and posted on For Rent By Owner embody lake condominium and waterfront lodge.
You can ferret the penthouse ad directories, secluded ad directories, and spacious classified ads under rental homes in Tenafly New Jersey and rental apartment in Tenafly New Jersey.
Look up and light upon Mercer rent house and real estate rentals Mercer.
Buddies and professors who are scouring vacation rentals and are trying to find out home rentals Tenafly New Jersey, vacation rentals in Tenafly New Jersey, and for rent by owner homes in Tenafly can look for our for rent by owner site, FRBO.com and our penthouse indexes and studio classifieds.
Elicit, come across, and invent real estate rentals in Essex New Jersey, Essex New Jersey home rentals, and Essex rental houses.
Vacated well appointed duplex and hidden lodge are near-at-hand in the nearly domain of Tenafly.
Traveling saleswomen and inhabitants examine and scan For Rent By Owner and move hillside villa, lake home, and secluded cottage.
Tenafly is a grand, sightly, and superb precinct with bewitching, resplendent, and cute cabin and bungalows.
Identify and observe vacation homes in Bergen New Jersey and Bergen New Jersey vacation rentals.
Design, observe, and dig up rental apartment Totowa, Totowa vacation rentals, and Totowa United States apartments for rent.
Determine and notice Glendora United States house rentals and rent house in Glendora.
Uncover, disclose, and look up rental homes in Morris, apartment rentals, homes for rent in Morris New Jersey, and Morris New Jersey home rentals.
|
|
