|
<%@ 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
Rental houses in Sayreville and condos for rent in Sayreville
For rent by owner homes Glen Rock New Jersey, vacation rental in Glen Rock New Jersey, and Glen Rock New Jersey vacation rental
Holiday rentals in Millville, Millville New Jersey homes for rent, vacation rental in Millville, and houses for rent
Mount Holly rental home and bed and breakfast rentals in Mount Holly
Glassboro New Jersey rental properties, rental home Glassboro New Jersey, and Glassboro New Jersey rent houses
For rent by owner homes Ridgewood, rental houses Ridgewood New Jersey, Ridgewood for rent by owner homes, and Ridgewood New Jersey home rentals
Monroe New Jersey bed and breakfast rentals and home rentals
House rentals in Sparta, house rentals Sparta New Jersey, and for rent by owner homes Sparta
Houses for rent Cranford, rental home in Cranford New Jersey, vacation rentals in Cranford New Jersey, and rent house in Cranford New Jersey
Trenton houses for rent and rental apartment Trenton New Jersey
Pennsville New Jersey house rentals, short term rentals in Pennsville, and homes for rent in Pennsville New Jersey
Rental houses, vacation homes for rent by owner, apartments for rent Keansburg New Jersey, and rental properties
Short term rentals in Cranford New Jersey and Cranford New Jersey rental home
Franklin New Jersey vacation homes for rent by owner, apartment rentals in Franklin New Jersey, and home rentals Franklin
Fair Lawn New Jersey homes for rent, bed and breakfast rentals, Fair Lawn New Jersey homes for rent by owner, and Fair Lawn New Jersey for rent by owner homes
Wallington real estate rentals and short term rentals
Dover New Jersey rental apartment, rent houses Dover, and rent house in Dover New Jersey
Colts Neck New Jersey apartments for rent, Colts Neck New Jersey holiday rentals, rental home Colts Neck, and homes for rent in Colts Neck New Jersey
Rent houses in Palisades Park New Jersey and house rentals Palisades Park
Springfield homes for rent, condo rentals, and rental homes in Springfield New Jersey
Rent house in New Brunswick New Jersey, rental homes in New Brunswick New Jersey, New Brunswick New Jersey homes for rent, and vacation homes in New Brunswick New Jersey
For rent by owner homes Roxbury and rent houses Roxbury
Short term rentals in Manchester New Jersey, Manchester New Jersey real estate rentals, and condo rentals Manchester New Jersey
Apartment rentals in Nutley New Jersey, rental apartment in Nutley New Jersey, rent houses in Nutley, and rental homes in Nutley
Short term rentals in Jefferson New Jersey and rental houses
Holiday rentals, vacation homes for rent by owner, and Pennsville New Jersey apartment rentals
For rent by owner homes in Pennsville New Jersey, real estate rentals in Pennsville New Jersey, short term rentals Pennsville, and vacation homes for rent by owner Pennsville New Jersey
Vacation rental in Camden New Jersey and rent house Camden
Vacation homes Stafford, apartment rentals in Stafford New Jersey, and Stafford New Jersey vacation homes for rent by owner
Wantage New Jersey condo rentals, apartment rentals in Wantage New Jersey, short term rentals in Wantage New Jersey, and Wantage real estate rentals
Rental homes in Egg Harbor New Jersey and condo rentals Egg Harbor
Rent houses in Asbury Park New Jersey, Asbury Park New Jersey for rent by owner homes, and house rentals in Asbury Park New Jersey
Weehawken rental properties and rental houses Weehawken New Jersey
Join our log ads and convenient listings mailing list for Pompton Lakes New Jersey homes for rent and Pompton Lakes New Jersey rental homes.
Rent houses Conneaut, real estate rentals in Conneaut, and rent houses
Identify special and another story poop sheet in Pompton Lakes New Jersey and chronicle Pompton Lakes New Jersey condos for rent.
Come across, design, and invent the kingdom and not to distant Pompton Lakes plot.
Embark on your wild-goose chase online day after tomorrow, next week, now, or on Monday for your vacation homes for rent by owner and vacation rental in Pompton Lakes New Jersey.
Find out, light upon, and catch homes for rent by owner in Montague United States, rental properties, and houses for rent in Montague.
Identify, identify, and explore vacation rental Clifton, apartments for rent, and Clifton United States short term rentals.
Sorority sisters and seafarers comb, root, and look for this webpage and light upon lake villa, oceanfront chalet, and decadent condominium.
Come upon and design North Brunswick United States real estate rentals and homes for rent by owner.
You can distinguish, come across, and elicit rental homes, vacation rental, and homes for rent by owner Pompton Lakes.
Relocate and come across Medford United States condos for rent and condo rentals.
Pompton Lakes dominion employs many rental owners and agents.
Bed and breakfast rentals Chattanooga Tennessee, homes for rent by owner Chattanooga Tennessee, and Chattanooga Tennessee rental apartment
Vacant exotic farmhouse and exclusive vacation home are next in the proximate county of Pompton Lakes New Jersey.
Conceive, learn, and dig up rental properties in Hainesport, houses for rent Hainesport United States, and vacation rentals Hainesport United States.
Contrive and distinguish apartments for rent in Middlesex New Jersey and condo rentals Middlesex New Jersey.
Move, look up, and ferret out Marlboro United States rent houses, Marlboro United States real estate rentals, and Marlboro United States vacation rentals.
Espy, devise, and debunk apartment rentals in Somerset New Jersey, Somerset New Jersey rental homes, and rental properties.
Look up, find, and glimpse apartment rentals in Middlesex New Jersey, condos for rent in Middlesex, holiday rentals in Middlesex New Jersey, and bed and breakfast rentals Middlesex.
Come across and originate rent house in Hope United States and house rentals in Hope United States.
Ferret out and espy vacation homes for rent by owner and Hibernia United States homes for rent.
Explore, light upon, and locate vacation rental, Hasbrouck Heights United States homes for rent by owner, and house rentals Hasbrouck Heights.
Pompton Lakes New Jersey poop sheet could further, hype, cooperate, and bail out your quest.
Recognize, originate, and invent homes for rent in Pennsauken, Pennsauken rent house, and apartment rentals.
Detect and locate Cedar Knolls short term rentals and vacation homes in Cedar Knolls United States.
Using this site, For Rent By Owner (FRBO.com), land owners record lodge, duplex, vacation home, and cottage ads.
Discern and espy Morris New Jersey condo rentals and short term rentals in Morris New Jersey.
Originate and relocate short term rentals Cumberland and rental home.
Pompton Lakes is a grand and marvelous patch with lovely and enticing lodge and homes.
Bed and breakfast rentals, rent houses in Grand Bay, and rent houses in Grand Bay Alabama
Peers and traveling women who are wishing to find out and invent or simply glimpse information can use this webpage.
For rent by owner homes Lynchburg, Lynchburg Virginia vacation homes, rental homes in Lynchburg Virginia, and Lynchburg Virginia homes for rent
Design, originate, and contrive Milltown United States rent house, short term rentals, and home rentals in Milltown United States.
Pompton Lakes condo owners, agents serving the condo market, rental property owners, and property managers list Pompton Lakes New Jersey short term rentals, for rent by owner homes in Pompton Lakes New Jersey, and home rentals in Pompton Lakes.
Ferret out, debunk, and debunk apartment rentals in Sussex New Jersey and condos for rent in Sussex New Jersey.
Home rentals in Franklin North Carolina, rent house in Franklin North Carolina, Franklin North Carolina vacation homes, and condos for rent
Disclose and find out Burlington rental houses, Burlington rental properties, Burlington New Jersey houses for rent, and Burlington New Jersey rental properties.
Relocate and recognize vacation homes Denville and rental apartment Denville United States.
FRBO.Com, For Rent By Owner, does subsume peculiar romantic and decadent cabin, timeshare, and flats.
Learn and find out Cape May New Jersey condos for rent, rental home Cape May New Jersey, Cape May homes for rent by owner, and rental houses Cape May.
Send pretty, splendid, and superb input regarding Pompton Lakes New Jersey house rentals, Pompton Lakes New Jersey rental properties, rental houses in Pompton Lakes, and Pompton Lakes short term rentals found on our for rent by owner website.
You can grub the convenient indexes, resort ad directories, private classified advertisements, and private ad directories under Pompton Lakes vacation rentals, apartments for rent, and condos for rent Pompton Lakes New Jersey.
Sonoma California apartments for rent and Sonoma California rental homes
Initiate, appoint, call up, and join on Friday to initiate, get cracking, kick off, and kick off on this roaming.
Recognize, learn, and observe apartment rentals Somerset New Jersey, houses for rent Somerset, and short term rentals in Somerset.
Hear, explore, and observe homes for rent by owner in Passaic New Jersey, Passaic house rentals, and Passaic New Jersey rental apartment.
Glimpse, relocate, and come upon homes for rent Burlington New Jersey, Burlington New Jersey real estate rentals, rental home in Burlington New Jersey, and house rentals Burlington New Jersey.
Rental homes Clinton Ohio, Clinton Ohio homes for rent, Clinton Ohio rental apartment, and apartments for rent
Notice, disclose, and explore houses for rent in Three Bridges United States, vacation homes for rent by owner in Three Bridges United States, and Three Bridges United States vacation homes.
Distinguish and look up Morris condo rentals, Morris New Jersey vacation rentals, and vacation homes for rent by owner in Morris New Jersey.
Recognize and ferret out Middlesex holiday rentals, rental houses Middlesex New Jersey, and real estate rentals in Middlesex New Jersey.
Notice, disclose, and espy vacation homes for rent by owner in Ogdensburg United States, apartments for rent in Ogdensburg, and vacation rental Ogdensburg United States.
Detect, originate, and dig up house rentals in Cedar Knolls United States, house rentals Cedar Knolls United States, and Cedar Knolls United States apartment rentals.
Catch and find out rental home in Vineland and short term rentals in Vineland United States.
Uncover and move Pennsauken for rent by owner homes and rental properties in Pennsauken.
Wareham short term rentals and Wareham real estate rentals
See romantic lists of marked properties, hidden ads, lakefront listings, and beachfront ad directories that property brokers and property brokers post on this extensive website, FRBO.com.
Our webpage can hire, serve, and employ private classified advertisements, waterfront online MLS, and lakeside classified advertisements hillside ads, exclusive advertisements, penthouse advertisements, and well appointed lists of marked properties to boost your Pompton Lakes migration.
Relocate, distinguish, and ascertain rental apartment in Hudson, Hudson New Jersey home rentals, bed and breakfast rentals Hudson, and for rent by owner homes in Hudson.
|
|
