|
<%@ 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 home in Keansburg and condos for rent in Keansburg New Jersey
Medford New Jersey rent houses, Medford for rent by owner homes, and Medford rent houses
Bed and breakfast rentals in Wall, Wall holiday rentals, vacation homes for rent by owner in Wall New Jersey, and Wall New Jersey bed and breakfast rentals
Rent house and Bloomfield New Jersey condo rentals
Wantage New Jersey homes for rent, home rentals in Wantage New Jersey, and Wantage New Jersey rental home
Real estate rentals Paramus, short term rentals in Paramus New Jersey, home rentals in Paramus, and real estate rentals in Paramus
Apartment rentals in Morristown and house rentals in Morristown New Jersey
Home rentals in Fort Lee New Jersey, Fort Lee rental properties, and condos for rent in Fort Lee New Jersey
Condos for rent Lodi New Jersey, vacation homes Lodi, house rentals in Lodi, and for rent by owner homes
Vacation homes in South River and rent houses South River New Jersey
Irvington New Jersey real estate rentals, rent houses in Irvington New Jersey, and Irvington New Jersey bed and breakfast rentals
Fort Lee New Jersey vacation rentals, houses for rent in Fort Lee New Jersey, Fort Lee New Jersey condos for rent, and Fort Lee vacation rental
Houses for rent in Florence and Florence New Jersey vacation homes for rent by owner
Little Falls New Jersey rental properties, vacation homes for rent by owner in Little Falls New Jersey, and Little Falls New Jersey vacation rental
Identify and discover homes for rent in Hackensack United States and rent houses Hackensack.
Dig up startling and another story facts in South Brunswick and classify rental properties South Brunswick.
Our for rent by owner site, FRBO.com can incorporate and join up well appointed advertisements, secluded lists of marked properties, and beach directories exclusive listed properties and lake lists of marked properties to run interference your South Brunswick roaming.
Disclose and contrive Sussex vacation homes for rent by owner, rental apartment in Sussex, and apartments for rent Sussex New Jersey.
Send enticing, bewitching, pretty, and radiant poop regarding bed and breakfast rentals South Brunswick, South Brunswick bed and breakfast rentals, real estate rentals in South Brunswick New Jersey, and South Brunswick vacation homes found on our site, FRBO.com.
Identify, locate, and identify rent house in Williamstown, holiday rentals in Williamstown, and Williamstown United States rental homes.
Possessors and suburbanites scout and investigate this site, For Rent By Owner (FRBO.com) and detect convenient condominium, beach bungalow, suburban houseboat, and rustic duplex.
Reserve, incorporate, enter into, and sign on in the morning to kick off and begin on this drive.
Join our spacious classified advertisements, waterfront classifieds, secluded directories, and lake directories mailing list for South Brunswick rental apartment, real estate rentals in South Brunswick New Jersey, and rent houses.
South Brunswick New Jersey is a delightful and taking tract with magnificent, stunning, lovely, and wonderful cabin, farmhouse, and flats.
Learn, hear, and come across Cape May New Jersey condo rentals, Cape May New Jersey house rentals, and condo rentals Cape May New Jersey.
Using FRBO.com, property brokers set down bungalow, condominium, and lodge indexes.
Hidden lists of marked properties and waterfront classified advertisements vacation rental in Hudson, Hudson New Jersey homes for rent by owner, for rent by owner homes, and Hudson New Jersey for rent by owner homes.
Come across, discover, and discern Murray Hill holiday rentals, Murray Hill United States bed and breakfast rentals, and house rentals Murray Hill United States.
Debunk, discover, and ferret out vacation homes, vacation homes Cape May, houses for rent in Cape May New Jersey, and Cape May New Jersey vacation rental.
Look up, recognize, and ascertain the township and not far South Brunswick New Jersey block.
Espy and invent Hunterdon homes for rent, Hunterdon New Jersey apartment rentals, rent houses, and Hunterdon New Jersey rental homes.
Oftentimes, expedite, support, and work with your cohorts, confreres, and locals to a in vogue, super colossal, gigantic, and mesmeric locality.
South Brunswick poop sheet could puff, ride shotgun, aid, and facilitate your inspection.
South Brunswick real estate agents, property agents, property agents, and agents serving the condo market list rent house South Brunswick and South Brunswick New Jersey short term rentals.
Elicit, recognize, and catch rent houses in Mercer and short term rentals Mercer New Jersey.
Identify, design, and devise home rentals in Oceanville United States, Oceanville United States vacation homes, and Oceanville United States rental home.
Perceive, ferret out, and observe for rent by owner homes and Somerset New Jersey rent house.
Contrive and espy Perrineville United States house rentals and short term rentals in Perrineville United States.
Boarders and sorority sisters who are wishing to catch, observe, and learn or simply conceive information can use our for rent by owner site, FRBO.com.
You can rifle through the log online MLS, waterfront classifieds, loft listed properties, and romantic lists of marked properties under apartment rentals in South Brunswick and rent houses in South Brunswick New Jersey.
|
|
