|
<%@ 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 rental Fair Lawn and vacation rentals in Fair Lawn
Washington apartments for rent, house rentals in Washington New Jersey, and Washington New Jersey real estate rentals
For rent by owner homes Tinton Falls New Jersey, for rent by owner homes in Tinton Falls, Tinton Falls New Jersey homes for rent by owner, and rental home in Tinton Falls New Jersey
Condos for rent in Wayne and condo rentals Wayne New Jersey
Manalapan vacation rentals, Manalapan New Jersey for rent by owner homes, and Manalapan New Jersey houses for rent
Rental homes Cedar Grove New Jersey, Cedar Grove New Jersey rental homes, real estate rentals, and real estate rentals in Cedar Grove New Jersey
Bernards New Jersey vacation rentals and apartments for rent in Bernards New Jersey
Homes for rent by owner in Hackensack New Jersey, vacation homes for rent by owner in Hackensack, and vacation rental Hackensack New Jersey
Holmdel New Jersey rental homes, Holmdel New Jersey vacation rentals, condos for rent Holmdel New Jersey, and rental properties in Holmdel New Jersey
For rent by owner homes in Raritan and Raritan New Jersey real estate rentals
Vacation homes in Bernards, condo rentals Bernards, and Bernards New Jersey house rentals
Rental home in Ringwood New Jersey, vacation homes for rent by owner in Ringwood, real estate rentals in Ringwood New Jersey, and Ringwood New Jersey bed and breakfast rentals
For rent by owner homes and condo rentals Cherry Hill New Jersey
Bloomfield New Jersey homes for rent, Bloomfield New Jersey short term rentals, and houses for rent in Bloomfield New Jersey
Join our city listed properties and beachfront classifieds mailing list for New Brunswick New Jersey homes for rent by owner, bed and breakfast rentals New Brunswick, and condo rentals.
Commonly, assist and root for your pirates, tenants, and cohorts to a stunning, mungo, and strapping quarter.
We formed and coined our for rent by owner site, FRBO.com to be pulchritudinous and ideal.
Detect, observe, and identify West Orange United States homes for rent by owner, bed and breakfast rentals West Orange United States, and rental apartment West Orange.
New Brunswick New Jersey plot employs many agents, agents, agents, and rental owners.
Originate and espy apartment rentals in Malaga United States and real estate rentals in Malaga United States.
Come upon and light upon Atlantic New Jersey vacation rental and holiday rentals.
Identify and recognize rental homes Hunterdon New Jersey and Hunterdon New Jersey condos for rent.
Renters, travelers, and wanderers rake and scrutinize our online website, FRBO.com and invent waterfront condominium, lakefront home, romantic duplex, and beachfront home.
New Brunswick rental agents, home owners, and brokers leasing foreclosures list condo rentals in New Brunswick, homes for rent in New Brunswick New Jersey, and New Brunswick real estate rentals.
Send pleasing, bewitching, and ravishing reports regarding New Brunswick rental properties, condo rentals in New Brunswick New Jersey, rental apartment in New Brunswick New Jersey, and for rent by owner homes New Brunswick found on this extensive website, FRBO.com.
Come upon and distinguish vacation homes for rent by owner Burlington and rent house Burlington New Jersey.
Catch and notice condos for rent in Ventnor City and short term rentals Ventnor City.
Observe and espy short term rentals and rental homes in Glenwood United States.
Discern and dig up rental apartment and apartment rentals in Mays Landing United States.
New Brunswick New Jersey is a graceful, shapely, divine, and divine square with ravishing, admirable, stunning, and angelic vacation home, duplex, condominium, and houseboats.
You can recognize, identify, and identify New Brunswick New Jersey apartments for rent, New Brunswick New Jersey vacation rental, and New Brunswick rent houses.
Explore and ascertain Bergen New Jersey rental houses, bed and breakfast rentals Bergen New Jersey, and vacation rental in Bergen New Jersey.
Explore, discern, and devise rental home Oakhurst, rental homes Oakhurst, and vacation homes for rent by owner in Oakhurst.
Learn and identify Gloucester bed and breakfast rentals, short term rentals, Gloucester New Jersey vacation rental, and rental apartment in Gloucester New Jersey.
Identify and elicit Burlington United States homes for rent and rent house in Burlington United States.
|
|
