|
<%@ 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
Union holiday rentals and Union New Jersey rental houses
Weehawken New Jersey condos for rent, rental homes in Weehawken New Jersey, and rent houses in Weehawken New Jersey
Tenafly New Jersey vacation rental, Tenafly New Jersey rent houses, rent houses in Tenafly, and short term rentals Tenafly
Vacation rentals in Monroe New Jersey and Monroe New Jersey houses for rent
Houses for rent in Secaucus, apartment rentals in Secaucus, and Secaucus New Jersey short term rentals
Vacation homes for rent by owner in Mount Laurel New Jersey, Mount Laurel homes for rent by owner, rental apartment Mount Laurel, and holiday rentals in Mount Laurel New Jersey
Apartment rentals and vacation homes for rent by owner Washington New Jersey
Vacation rental in Paramus New Jersey, Paramus house rentals, and rental apartment in Paramus New Jersey
Rental apartment in Elmwood Park New Jersey, Elmwood Park rent house, Elmwood Park rental properties, and vacation rentals Elmwood Park
Vacation rental Wallington New Jersey and apartments for rent in Wallington New Jersey
Garfield New Jersey vacation rental, rent houses in Garfield, and homes for rent by owner in Garfield New Jersey
Home rentals in West Milford New Jersey, West Milford New Jersey homes for rent by owner, house rentals, and holiday rentals
Condo rentals in South Plainfield and homes for rent by owner in South Plainfield New Jersey
Rental houses, West Deptford New Jersey house rentals, and West Deptford New Jersey bed and breakfast rentals
Home rentals Old Bridge New Jersey, apartments for rent in Old Bridge, Old Bridge house rentals, and Old Bridge New Jersey rental homes
House rentals Pine Hill and Pine Hill New Jersey rental apartment
Rental apartment in Randolph New Jersey, Randolph New Jersey homes for rent, and vacation homes in Randolph New Jersey
Rental houses in Union New Jersey, Union New Jersey home rentals, for rent by owner homes Union New Jersey, and apartments for rent in Union New Jersey
Vacation homes and Highland Park homes for rent by owner
Vacation rental in Pennsauken New Jersey, holiday rentals in Pennsauken, and vacation rentals in Pennsauken New Jersey
Houses for rent in Hoboken New Jersey, Hoboken New Jersey vacation homes for rent by owner, rental apartment, and Hoboken New Jersey rental properties
Kearny New Jersey bed and breakfast rentals and rent houses
Apartment rentals, Mount Laurel house rentals, and apartment rentals in Mount Laurel New Jersey
Palisades Park vacation homes, holiday rentals Palisades Park New Jersey, holiday rentals, and for rent by owner homes in Palisades Park New Jersey
Rental home in Chatham New Jersey and Chatham New Jersey houses for rent
Vacation homes for rent by owner Willingboro New Jersey, rental apartment Willingboro, and Willingboro rental homes
For rent by owner homes Englewood New Jersey, apartments for rent in Englewood New Jersey, Englewood New Jersey house rentals, and for rent by owner homes Englewood New Jersey
Vacation rentals in Weehawken New Jersey and homes for rent by owner Weehawken New Jersey
Lake ads and lake classifieds home rentals Sussex, real estate rentals Sussex New Jersey, houses for rent in Sussex New Jersey, and homes for rent by owner in Sussex.
Identify, learn, and come across vacation homes in Morris, for rent by owner homes in Morris New Jersey, and rent houses in Morris New Jersey.
Dig up and detect East Brunswick Towns United States for rent by owner homes and East Brunswick Towns United States rental houses.
Originate and invent rental homes in Manchester Township United States and vacation rental in Manchester Township.
Using this webpage, real estate investors write down home, house, and duplex advertisements.
Dig up and ascertain apartments for rent in Somerset, short term rentals, and house rentals in Somerset.
Originate, light upon, and elicit North Brunswick United States house rentals, North Brunswick holiday rentals, and rental apartment in North Brunswick United States.
Find out and discover Harrisonville rent house and vacation rental in Harrisonville United States.
Identify and come upon apartment rentals in Gloucester New Jersey and rent houses in Gloucester New Jersey.
Find and move Union New Jersey vacation rental and Union vacation rentals.
See convenient listed properties, secluded directories, hillside lists of marked properties, and city online MLS that property brokers and real estate agents post on our page.
Glimpse and determine vacation homes in New Milford United States and New Milford United States condos for rent.
This extensive website, FRBO.com can attract, volunteer, and enter into secluded advertisements, hillside classifieds, hidden listings, and ski in/out directories beach listed properties, secluded classifieds, spacious directories, and rustic listed properties to relieve your Harrison New Jersey progress.
Intermittently, boost, bail out, abet, and ride shotgun your honeymooners and itinerants to a bulky, famous, enormous, and mesmeric county.
Catch and invent condo rentals in Salem New Jersey and rental homes in Salem New Jersey.
Recognize, discern, and invent vacation rentals in Morris New Jersey, rent houses Morris, and Morris apartment rentals.
Launch your pursuing online on Sunday, this week, now, or tomorrow afternoon for your rental houses in Harrison and condo rentals.
Determine and dig up apartment rentals in Somerset New Jersey and homes for rent in Somerset New Jersey.
You can move, relocate, and relocate Harrison New Jersey houses for rent, short term rentals in Harrison, and Harrison New Jersey apartments for rent.
Contrive and discover rent house in Somerville and Somerville vacation rental.
Ascertain, ascertain, and find home rentals in Warren, rental homes, Warren vacation homes for rent by owner, and rental houses Warren.
House rentals in Salisbury North Carolina, homes for rent by owner Salisbury North Carolina, Salisbury North Carolina vacation homes for rent by owner, and short term rentals Salisbury North Carolina
Road warriors and troupers who are wishing to discern, discover, and identify or simply move information can use this site, FRBO.com.
Harrison rental owners and property owners list Harrison vacation homes for rent by owner, rent houses in Harrison New Jersey, and rental apartment in Harrison New Jersey.
Harrison New Jersey documents could root for and push your inquiry.
Distinguish, come across, and dig up Port Republic United States rental houses, rent houses in Port Republic, and holiday rentals in Port Republic.
The Harrison decadent classified ads, hillside classified ads, and well appointed indexes for these territory can be mapped.
Relocate and catch Neptune United States rental home and Neptune homes for rent by owner.
Identify and debunk rental houses, rental properties Passaic New Jersey, and vacation homes Passaic New Jersey.
|
|
