|
<%@ 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
Real estate rentals in Readington New Jersey and vacation homes for rent by owner
Rent houses in East Windsor New Jersey, rent houses East Windsor, and homes for rent in East Windsor New Jersey
Apartment rentals Hawthorne New Jersey, Hawthorne homes for rent by owner, Hawthorne New Jersey vacation homes, and rental home
Washington rent houses and condos for rent in Washington New Jersey
Condo rentals Somerville New Jersey, vacation rental in Somerville New Jersey, and Somerville New Jersey apartment rentals
Warren New Jersey short term rentals, Warren New Jersey vacation homes for rent by owner, holiday rentals in Warren New Jersey, and Warren New Jersey short term rentals
Hackensack holiday rentals and Hackensack New Jersey vacation homes for rent by owner
Real estate rentals in Camden New Jersey, Camden houses for rent, and bed and breakfast rentals Camden
Ridgefield New Jersey rental apartment, Ridgefield New Jersey for rent by owner homes, Ridgefield New Jersey rental houses, and condo rentals in Ridgefield New Jersey
Condos for rent in Haddon New Jersey and bed and breakfast rentals in Haddon
Rental homes, Franklin New Jersey for rent by owner homes, and short term rentals in Franklin
The Hillside loft directories, waterfront advertisements, mountain ad directories, and log directories for these city can be mapped.
Recognize and disclose the county and approaching Hillside section.
Hear, learn, and explore houses for rent Essex and Essex New Jersey rent houses.
Come upon and design Asbury Park United States vacation homes for rent by owner and Asbury Park United States vacation rental.
Notice and disclose rental apartment Passaic New Jersey, Passaic rental apartment, homes for rent by owner Passaic, and Passaic New Jersey vacation rental.
Espy, uncover, and recognize vacation rentals in Union, houses for rent Union, and rent houses in Union New Jersey.
Householders and passengers who are wishing to relocate, design, and contrive or simply distinguish information can use our site, FRBO.com.
This website, FRBO.com can reserve and volunteer well appointed listed properties, resort directories, and spacious listed properties loft ads, beachfront ads, and suburban ad directories to expedite your Hillside route.
Learn and look up short term rentals and condos for rent in Landing United States.
Hillside New Jersey is a pulchritudinous, bewitching, and gorgeous territory with exquisite, admirable, bewitching, and statuesque villa, lodge, condominium, and castles.
Join our suburban lists of marked properties, decadent directories, waterfront classified advertisements, and hidden lists of marked properties mailing list for real estate rentals in Hillside New Jersey, vacation rentals in Hillside New Jersey, and Hillside New Jersey rental houses.
Lead off your research online on Monday or this week for your rental properties Hillside New Jersey, Hillside bed and breakfast rentals, and Hillside rental houses.
Hillside New Jersey reports could boost and relieve your pursuance.
Debunk, ascertain, and debunk house rentals, Lafayette United States homes for rent, and holiday rentals Lafayette.
Move, notice, and notice rental houses in Camden New Jersey and Camden condos for rent.
|
|
