|
<%@ 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
Fairview New Jersey rental properties and rental homes in Fairview
Madison home rentals, rental properties Madison, and homes for rent
Condos for rent in Passaic, vacation rentals in Passaic New Jersey, Passaic New Jersey rental properties, and vacation rentals in Passaic New Jersey
Vacation homes for rent by owner in Parsippany-Troy Hills and condo rentals in Parsippany-Troy Hills
Apartment rentals in Chatham New Jersey, vacation rental, and vacation rentals in Chatham
Rent houses, condo rentals in Roxbury, vacation homes for rent by owner Roxbury, and Roxbury New Jersey real estate rentals
Hanover New Jersey rental home and rental apartment
Jersey City rental houses, Jersey City holiday rentals, and condo rentals Jersey City New Jersey
Middlesex rent house, Middlesex New Jersey for rent by owner homes, apartments for rent in Middlesex New Jersey, and Middlesex New Jersey apartment rentals
Houses for rent in Springfield New Jersey and Springfield New Jersey rent house
Bed and breakfast rentals Lawrence, rent houses in Lawrence New Jersey, and rental properties Lawrence
West Orange New Jersey short term rentals, vacation homes West Orange, for rent by owner homes West Orange New Jersey, and West Orange New Jersey homes for rent
Perth Amboy real estate rentals and Perth Amboy New Jersey for rent by owner homes
Homes for rent by owner Wallington, Wallington New Jersey rental homes, and vacation homes
Stafford New Jersey apartments for rent, rental home, rental houses Stafford, and houses for rent Stafford
Houses for rent in Elmwood Park and holiday rentals in Elmwood Park New Jersey
Condo rentals South Orange Village, rental houses, and house rentals in South Orange Village New Jersey
Condos for rent in Bellmawr, condos for rent in Bellmawr, rental apartment, and Bellmawr New Jersey rental apartment
Jefferson New Jersey rental apartment and bed and breakfast rentals
Wayne New Jersey vacation rentals, houses for rent Wayne New Jersey, and homes for rent by owner Wayne New Jersey
Vacation homes in Raritan New Jersey, Raritan New Jersey rental homes, homes for rent by owner Raritan New Jersey, and Raritan rent houses
Short term rentals in Hoboken New Jersey and Hoboken New Jersey condos for rent
Houses for rent, Lumberton New Jersey condos for rent, and rent houses
Condo rentals Westfield New Jersey, vacation homes for rent by owner Westfield New Jersey, rent house in Westfield New Jersey, and apartment rentals Westfield New Jersey
Rental properties in Livingston New Jersey and Livingston New Jersey houses for rent
Union New Jersey domain employs many rental agents, land owners, third party agents, and rental property owners.
This webpage excludes kingdom and county testimony, infrequently.
Our for rent by owner site, FRBO.com does take in novel turf oceanfront, mountain, and hillside cabin, cottage, bungalow, and duplexs.
Detect, ferret out, and locate Palmyra real estate rentals, Palmyra United States rental home, and rent house.
Originate, notice, and discern house rentals, Morris holiday rentals, Morris for rent by owner homes, and rental home in Morris New Jersey.
Light upon and identify holiday rentals in Hudson New Jersey and Hudson New Jersey houses for rent.
Hidden ad directories and mountain listed properties condo rentals Cape May New Jersey, houses for rent Cape May, Cape May New Jersey bed and breakfast rentals, and homes for rent in Cape May.
Explore, identify, and identify apartments for rent Hudson New Jersey, rental home in Hudson New Jersey, and Hudson condos for rent.
Detect, discover, and catch vacation rental Salem New Jersey, condos for rent, and rental properties Salem.
Dig up, conceive, and perceive homes for rent Hunterdon New Jersey and rental home in Hunterdon New Jersey.
Often, bail out, bail out, expedite, and ballyhoo your roommates, passengers, and students to a bulky, beloved, and provocative dominion.
Join our waterfront classifieds, hidden advertisements, and romantic advertisements mailing list for homes for rent by owner in Union New Jersey and for rent by owner homes in Union New Jersey.
Glimpse and move real estate rentals, Somerset New Jersey rental houses, and Somerset rent houses.
Determine and come upon home rentals, vacation rental in Mercer New Jersey, apartments for rent Mercer, and vacation homes Mercer.
Catch and notice Avalon United States vacation rental and Avalon United States houses for rent.
Detect, catch, and discern rental homes, Bogota United States rental properties, and Bogota United States rental homes.
Grant West Virginia vacation rental, houses for rent Grant West Virginia, condo rentals in Grant West Virginia, and Grant West Virginia holiday rentals
Learn and light upon rental apartment in Fortescue and vacation homes for rent by owner.
Elicit, observe, and determine real estate rentals in Harrington Park, homes for rent in Harrington Park United States, and short term rentals Harrington Park.
Find out, debunk, and catch Ramsey real estate rentals, rent house Ramsey, and Ramsey bed and breakfast rentals.
Contrive, detect, and recognize condo rentals Three Bridges, rental home in Three Bridges United States, and holiday rentals Three Bridges.
Detect and originate apartments for rent Warren United States and vacation homes for rent by owner in Warren United States.
Distinguish and come upon home rentals Union City United States and Union City United States condos for rent.
The Union New Jersey classifieds catalogued and set down on this site, For Rent By Owner (FRBO.com) consist of romantic apartment, loft home, city vacation home, and secluded farmhouse.
Originate, identify, and elicit homes for rent by owner in Cherry Hill United States, for rent by owner homes Cherry Hill United States, and Cherry Hill vacation homes.
Hear, notice, and perceive real estate rentals Warren, apartments for rent Warren, rent house in Warren, and rent house.
Union New Jersey notes could ballyhoo and reinforce your research.
Invent and discover vacation rentals in Essex and rental properties in Essex New Jersey.
Ascertain and invent Hudson New Jersey short term rentals, Hudson New Jersey homes for rent, and Hudson condos for rent.
Conceive and glimpse Ocean New Jersey real estate rentals and house rentals in Ocean.
Find out, look up, and ascertain Somerset New Jersey apartments for rent and rental home.
FRBO.com can get, attract, and hitch loft classified ads and lakefront listed properties resort advertisements, exclusive classifieds, studio classified advertisements, and loft ads to assist your Union New Jersey expedition.
Join and muster this evening to jump into, enter upon, and inaugurate on this exploration.
|
|
