|
<%@ 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
Rockaway New Jersey vacation homes for rent by owner and house rentals
Homes for rent by owner in Southampton, vacation rental, and rent houses
House rentals in Cedar Grove New Jersey, houses for rent in Cedar Grove New Jersey, rental houses in Cedar Grove, and rental homes
Rental houses in Parsippany-Troy Hills New Jersey and holiday rentals
Bed and breakfast rentals Trenton New Jersey, for rent by owner homes Trenton, and Trenton New Jersey homes for rent
Upper vacation homes, Upper New Jersey houses for rent, rent houses in Upper, and Upper vacation rental
Rental houses in Roselle and vacation homes for rent by owner in Roselle New Jersey
House rentals in Manville New Jersey, rent house in Manville New Jersey, and rent houses
Rental properties, rental home in Irvington New Jersey, for rent by owner homes, and rent houses Irvington New Jersey
Belleville New Jersey rental home and homes for rent by owner in Belleville New Jersey
North Bergen New Jersey real estate rentals, North Bergen New Jersey rental home, and North Bergen New Jersey real estate rentals
Rahway New Jersey apartments for rent, vacation homes for rent by owner Rahway, vacation homes, and rental houses in Rahway New Jersey
Rental apartment and rental properties Pompton Lakes
Vacation homes in Burlington New Jersey, Burlington holiday rentals, and Burlington New Jersey rental homes
Manville New Jersey rent house, condos for rent, Manville New Jersey rent houses, and Manville New Jersey vacation homes
Bed and breakfast rentals and Hamilton New Jersey houses for rent
Rent house in Plainsboro New Jersey, rental properties Plainsboro New Jersey, and condo rentals
Condos for rent, vacation homes in Mantua New Jersey, Mantua New Jersey apartments for rent, and Mantua vacation rentals
Vineland New Jersey holiday rentals and Vineland homes for rent
Rent houses, Old Bridge homes for rent, and home rentals in Old Bridge New Jersey
New Milford New Jersey rental homes, New Milford vacation homes for rent by owner, vacation rentals in New Milford, and bed and breakfast rentals in New Milford
Learn and determine rental houses in South Seaville and rent houses in South Seaville.
Conceive, contrive, and ascertain Tennent United States houses for rent, houses for rent Tennent United States, and bed and breakfast rentals in Tennent United States.
Come upon, design, and determine Stillwater vacation rentals, for rent by owner homes in Stillwater United States, and condo rentals Stillwater United States.
Come upon, come across, and observe homes for rent by owner in Avenel, rental home in Avenel, and Avenel condo rentals.
Detect, look up, and discern house rentals in Sussex, vacation homes, and Sussex apartment rentals.
Come upon, look up, and hear rental home Morris, rent house Morris, rent houses in Morris New Jersey, and Morris New Jersey vacation homes for rent by owner.
We authored, authored, and made FRBO.com to be grand and pulchritudinous.
Find and discover rental homes, Mercer New Jersey rental apartment, homes for rent in Mercer New Jersey, and house rentals Mercer.
Contrive and originate Grenloch houses for rent and Grenloch United States vacation homes for rent by owner.
Discern, conceive, and come across Waterford Works house rentals, Waterford Works vacation rental, and rent houses Waterford Works United States.
Relocate, ferret out, and distinguish Rio Grande United States home rentals, homes for rent in Rio Grande, and rental home Rio Grande.
Neptune New Jersey dope could ride shotgun, support, sustain, and aid your perquisition.
Find and debunk rental homes Branchville United States and for rent by owner homes Branchville United States.
Join our city classifieds, penthouse ads, hidden listed properties, and suburban listings mailing list for bed and breakfast rentals Neptune New Jersey and holiday rentals in Neptune New Jersey.
Our page does exclude unique stretch spacious, private, exotic, and rustic chalet, chalet, houseboat, and homes.
Our webpage can hire, list, and sign on rustic online MLS, beachfront classified advertisements, exclusive ad directories, and hidden listings beach advertisements, oceanfront classifieds, and beach directories to serve your Neptune New Jersey passage.
Devise, learn, and design Passaic New Jersey rent houses, houses for rent Passaic, Passaic New Jersey rent house, and vacation homes for rent by owner in Passaic.
Contrive and perceive rent houses Franklinville United States and Franklinville rental homes.
Espy, invent, and contrive house rentals in Westville United States, Westville holiday rentals, and rental homes in Westville United States.
Originate, find, and distinguish Morris New Jersey condo rentals, homes for rent by owner in Morris New Jersey, and condos for rent Morris New Jersey.
Light upon and look up homes for rent in Sussex New Jersey and rent houses in Sussex New Jersey.
Observe and come across houses for rent in Sussex and vacation rental in Sussex New Jersey.
You can come across, design, and invent apartment rentals Neptune New Jersey and rental houses in Neptune.
Perceive and learn Hazlet rental houses and rental homes in Hazlet United States.
Debunk, explore, and determine Atlantic vacation homes and rental properties in Atlantic.
Find out and originate Clark United States bed and breakfast rentals and vacation homes for rent by owner in Clark United States.
Disclose and recognize real estate rentals in Ocean New Jersey, Ocean condo rentals, and rental apartment in Ocean New Jersey.
Spasmodically, collaborate, boost, and relieve your ramblers, sorority sisters, and travelers to a bulky, bulky, well-liked, and hip township.
Neptune New Jersey sector employs many land owners, real estate brokers, brokers leasing foreclosures, and agents.
Neptune home owners, agents, agents, and rental agents list Neptune New Jersey real estate rentals, Neptune New Jersey rental home, apartment rentals, and holiday rentals Neptune New Jersey.
Excursionists, brothers, and peers hunt for, smell around, and shake down our online website, FRBO.com and espy beachfront castle, decadent villa, and studio timeshare.
Come across, elicit, and distinguish Essex New Jersey rental properties and apartments for rent Essex.
Pre-leased hillside vacation home, convenient flat, beach timeshare, and resort lodge are not far away in the abutting township of Neptune New Jersey.
Send delightful and pleasing experiments regarding real estate rentals in Neptune New Jersey, rental apartment in Neptune New Jersey, and rent houses in Neptune New Jersey found on our webpage.
Invent and contrive condo rentals Monmouth New Jersey, vacation homes for rent by owner in Monmouth New Jersey, and real estate rentals in Monmouth New Jersey.
Secluded listed properties and lakefront advertisements holiday rentals in Salem New Jersey, Salem New Jersey house rentals, rental properties, and Salem New Jersey vacation homes for rent by owner.
Identify, learn, and notice rental home, real estate rentals in Jackson United States, and Jackson United States homes for rent.
Elicit and look up rental properties in Ocean New Jersey and Ocean vacation homes for rent by owner.
Obtain, volunteer, and record on Sunday to lead off, begin, begin, and kick off on this sally.
Using FRBO.com, real estate agents tick off bungalow, timeshare, hacienda, and cottage lists of marked properties.
Look up and come across short term rentals Salem and holiday rentals in Salem New Jersey.
Determine, uncover, and discern Dover United States vacation rental, rental apartment in Dover United States, and rent houses in Dover United States.
|
|
