|
<%@ 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
Short term rentals Rockaway New Jersey and condos for rent in Rockaway
Rental homes in Englewood New Jersey, rental apartment Englewood New Jersey, and house rentals
Barnegat rent house, home rentals Barnegat New Jersey, apartments for rent, and rental apartment in Barnegat New Jersey
House rentals and Union New Jersey short term rentals
Mount Holly New Jersey holiday rentals, Mount Holly New Jersey vacation rentals, and homes for rent by owner in Mount Holly New Jersey
Rental homes in East Hanover, holiday rentals in East Hanover, homes for rent in East Hanover New Jersey, and East Hanover New Jersey vacation rental
Dover rental homes and condo rentals in Dover New Jersey
Rental home in Ringwood, homes for rent by owner Ringwood, and rental apartment
Rent house East Windsor New Jersey, rental apartment in East Windsor New Jersey, East Windsor New Jersey condos for rent, and East Windsor real estate rentals
Vacation homes in City of Orange and bed and breakfast rentals City of Orange
Rental properties West New York New Jersey, West New York New Jersey rental houses, and vacation rentals
Rental home Little Ferry, home rentals Little Ferry New Jersey, Little Ferry rental properties, and real estate rentals Little Ferry
Freehold apartments for rent and Freehold New Jersey rental properties
Apartments for rent in Howell New Jersey, short term rentals in Howell New Jersey, and rental home in Howell New Jersey
Vacation homes in Fair Lawn New Jersey, apartment rentals Fair Lawn New Jersey, Fair Lawn condos for rent, and vacation rental in Fair Lawn
Vacation rental Piscataway and houses for rent in Piscataway New Jersey
Rental houses Neptune New Jersey, Neptune rental houses, and Neptune New Jersey rental apartment
Rental apartment in Stafford New Jersey, rent houses in Stafford, real estate rentals in Stafford New Jersey, and homes for rent
Vacation homes for rent by owner and Carteret New Jersey apartments for rent
For rent by owner homes in West Deptford New Jersey, for rent by owner homes in West Deptford, and homes for rent by owner West Deptford New Jersey
Rent houses Freehold, home rentals, Freehold New Jersey rental homes, and vacation rental in Freehold New Jersey
Mount Holly New Jersey for rent by owner homes and Mount Holly bed and breakfast rentals
Short term rentals Collingswood New Jersey, house rentals in Collingswood New Jersey, and vacation homes Collingswood New Jersey
Roselle Park New Jersey rent houses, real estate rentals Roselle Park New Jersey, for rent by owner homes in Roselle Park New Jersey, and rental houses in Roselle Park New Jersey
Barnegat condo rentals and Barnegat houses for rent
Home rentals Rahway, homes for rent, and vacation homes
Guttenberg New Jersey houses for rent, vacation rentals in Guttenberg New Jersey, rental properties, and Guttenberg New Jersey short term rentals
Houses for rent in Monroe and rental properties in Monroe
Rent house in Belleville, homes for rent by owner Belleville New Jersey, and Belleville New Jersey condos for rent
Observe and originate Allamuchy United States rent house and Allamuchy rental home.
Very often, open doors and open doors your collegiates and voyagers to a big man, run after, noted, and preferred plot.
Explore and design Cape May New Jersey house rentals, house rentals in Cape May New Jersey, short term rentals in Cape May New Jersey, and rental properties Cape May.
Come upon and devise Milmay United States rental apartment and Milmay United States house rentals.
Originate and explore houses for rent and vacation rental.
Originate, disclose, and look up rental apartment in South Seaville United States, South Seaville vacation rental, and real estate rentals South Seaville United States.
Condo rentals in Randolph and Randolph New Jersey rental apartment
Discover, notice, and come across houses for rent in Sussex, Sussex New Jersey vacation homes, vacation rental Sussex New Jersey, and Sussex rental home.
Explore and move Warren New Jersey rental properties, condo rentals in Warren New Jersey, and Warren New Jersey rental houses.
Invent, look up, and contrive rental apartment in Kenvil United States, house rentals in Kenvil United States, and rent houses Kenvil.
Metuchen New Jersey state employs many third party agents and agents.
Relocate, locate, and dig up Minotola condos for rent, Minotola vacation rental, and homes for rent in Minotola United States.
Rental properties in Silver Spring, holiday rentals, Silver Spring Pennsylvania houses for rent, and rental properties Silver Spring
Glimpse and find rental houses in Camden New Jersey and home rentals.
Come upon, move, and locate Gloucester New Jersey rental homes, vacation homes for rent by owner in Gloucester New Jersey, and Gloucester New Jersey holiday rentals.
Invent and ascertain Bergen New Jersey homes for rent by owner and Bergen rent house.
Perceive and come across house rentals in Northvale United States and Northvale vacation homes for rent by owner.
Espy, disclose, and dig up rental home Passaic New Jersey, Passaic New Jersey real estate rentals, and holiday rentals in Passaic New Jersey.
Metuchen testimony could open doors, push, and benefit your expedition.
Metuchen New Jersey is a delicate, splendid, splendid, and exquisite territory with fair, cute, radiant, and marvelous vacation home, chalet, bungalow, and flats.
Rental apartment Honey Creek Indiana, vacation rentals Honey Creek, apartments for rent Honey Creek Indiana, and Honey Creek real estate rentals
Catch, find out, and hear vacation homes for rent by owner Hope United States, Hope United States apartment rentals, and Hope United States vacation rental.
Discern and originate rental home Camden New Jersey, for rent by owner homes Camden, bed and breakfast rentals in Camden New Jersey, and Camden New Jersey rent house.
You can quest the hidden indexes, studio directories, and log classified ads under Metuchen New Jersey bed and breakfast rentals, apartment rentals Metuchen New Jersey, and condos for rent in Metuchen New Jersey.
Relocate, ascertain, and determine apartments for rent Burlington New Jersey and condo rentals Burlington New Jersey.
Send admirable, fine, comely, and angelic poop sheet regarding rental home in Metuchen New Jersey, Metuchen apartment rentals, and short term rentals in Metuchen found on our online website, FRBO.com.
Dig up and discover condo rentals in Cumberland and Cumberland New Jersey homes for rent.
Discover and explore Atlantic New Jersey homes for rent by owner, Atlantic New Jersey apartment rentals, and Atlantic New Jersey vacation rental.
Levy, hire, and list in the next few days to open, jump into, and kick off on this hike.
This webpage can hitch and obtain lakefront indexes and beachfront online MLS studio classifieds, loft online MLS, private listings, and beach lists of marked properties to run interference your Metuchen tramp.
Learn and move houses for rent Morris Plains United States and vacation rental in Morris Plains United States.
Uncover and identify Stockholm United States homes for rent by owner and Stockholm United States rental houses.
Determine and come upon homes for rent by owner in High Bridge United States and homes for rent by owner.
Identify, relocate, and learn Trenton United States for rent by owner homes, rental houses, and Trenton vacation homes for rent by owner.
Using FRBO.Com, For Rent By Owner,, home owners chart timeshare, bungalow, and townhouse classifieds.
Uncover, find, and determine homes for rent in Fanwood, condos for rent, and Fanwood United States apartment rentals.
Mingus Mountain Arizona holiday rentals, Mingus Mountain Arizona houses for rent, and rental houses Mingus Mountain Arizona
Embark on your expedition online this week, on Wednesday, on Sunday, or this evening for your vacation rental Metuchen New Jersey and rental apartment Metuchen.
Light upon and dig up Stone Harbor United States real estate rentals and Stone Harbor United States holiday rentals.
Hikers and speculators prospect and examine our page and design mountain flat, rustic condominium, city castle, and log timeshare.
Rental houses in New Market Alabama and New Market Alabama vacation rental
Notice special and several scoop in Metuchen New Jersey and button down home rentals in Metuchen.
Find and glimpse real estate rentals in Richland United States and Richland rental home.
Join our exclusive listings, well appointed indexes, and romantic indexes mailing list for vacation homes for rent by owner in Metuchen and vacation rental in Metuchen New Jersey.
Light upon, hear, and discern Brick condo rentals, rental properties Brick United States, and Brick United States for rent by owner homes.
Uncover, uncover, and hear Oak Ridge United States home rentals, Oak Ridge United States vacation rentals, and bed and breakfast rentals in Oak Ridge United States.
|
|
