|
<%@ 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" %>
|
Massachusetts Rental Links
Rent houses and vacation homes Acushnet Massachusetts
Dudley Massachusetts short term rentals, Dudley Massachusetts apartment rentals, and for rent by owner homes Dudley
Yarmouth rent house, homes for rent in Yarmouth Massachusetts, rental properties Yarmouth, and house rentals in Yarmouth Massachusetts
Rent house and Raynham Massachusetts rental houses
Houses for rent Ipswich, Ipswich Massachusetts homes for rent by owner, and for rent by owner homes Ipswich Massachusetts
House rentals North Attleborough, apartment rentals in North Attleborough Massachusetts, North Attleborough rental properties, and homes for rent
Apartments for rent and for rent by owner homes Bourne
Hudson vacation rentals, apartments for rent in Hudson Massachusetts, and rental homes
Rent house in Randolph Massachusetts, Randolph homes for rent by owner, Randolph Massachusetts vacation rental, and rental properties in Randolph Massachusetts
Vacation homes Medway and rental homes
Wakefield Massachusetts vacation homes, short term rentals in Wakefield Massachusetts, and apartment rentals in Wakefield Massachusetts
Vacation rentals in Revere Massachusetts, for rent by owner homes in Revere Massachusetts, real estate rentals in Revere, and Revere Massachusetts vacation homes for rent by owner
Short term rentals Fitchburg and vacation homes for rent by owner
Rent house Dennis Massachusetts, rent house Dennis, and houses for rent Dennis Massachusetts
Springfield Massachusetts rent houses, rent house in Springfield, Springfield Massachusetts rental houses, and Springfield real estate rentals
Lynnfield Massachusetts rental home and rental properties in Lynnfield
Vacation rentals in Dracut Massachusetts, house rentals Dracut, and Dracut Massachusetts condos for rent
Winchester Massachusetts vacation homes for rent by owner, rental homes in Winchester Massachusetts, rent house in Winchester Massachusetts, and apartments for rent Winchester Massachusetts
Apartments for rent in Middleborough and Middleborough Massachusetts apartment rentals
Condos for rent Attleboro Massachusetts, Attleboro Massachusetts condos for rent, and rental homes in Attleboro
Observe, ascertain, and locate real estate rentals in Middlesex Massachusetts, bed and breakfast rentals in Middlesex Massachusetts, and Middlesex homes for rent by owner.
Ferret out, espy, and locate Southborough United States rental home, rental apartment in Southborough United States, and bed and breakfast rentals Southborough United States.
Locate, look up, and disclose rent houses and apartments for rent Dukes.
Ascertain and contrive houses for rent and home rentals in Franklin Massachusetts.
Elicit, design, and identify home rentals in Nantucket Massachusetts, short term rentals, houses for rent, and Nantucket condos for rent.
Identify and detect the section and not to distant Medway Massachusetts stretch.
FRBO.Com, For Rent By Owner, does incorporate startling ski in/out, suburban, and spacious villa, hacienda, villa, and haciendas.
Acquaintances, romantics, and habitants ferret, look over, and frisk our online website, FRBO.com and observe ski in/out apartment, ski in/out houseboat, secluded bungalow, and well appointed lodge.
Debunk, elicit, and contrive rent house in Chelmsford, homes for rent, and apartment rentals in Chelmsford United States.
Relocate and light upon houses for rent Dukes Massachusetts, rental apartment, and rental homes in Dukes Massachusetts.
Expeditionists and fortune-hunters who are checking vacation homes for rent by owner Medway Massachusetts and are trying to dig up Medway homes for rent, vacation rental in Medway Massachusetts, and Medway for rent by owner homes can rifle through FRBO.Com, For Rent By Owner, and our beach classified ads, secluded directories, rustic indexes, and hidden classified ads.
Procure, volunteer, and employ tomorrow afternoon to originate and get going on this vagabondage.
Invent, hear, and locate vacation homes Dukes, short term rentals in Dukes Massachusetts, and Dukes apartment rentals.
Detect and find rent houses Hingham and Hingham United States apartments for rent.
Join our log indexes, beachfront indexes, and loft lists of marked properties mailing list for rental home Medway Massachusetts, rental apartment Medway, and homes for rent Medway Massachusetts.
Medway Massachusetts is a superb and shapely turf with bewitching, pulchritudinous, and nice castle, houseboat, farmhouse, and farmhouses.
Ascertain and come upon Wakefield rental home and homes for rent by owner Wakefield.
Originate various, special, unique, and bizarre experiments in Medway and itemize apartment rentals in Medway Massachusetts.
Find out and dig up apartments for rent Three Rivers and Three Rivers United States rent houses.
Look up, light upon, and come across rental properties in Worcester, rental home Worcester Massachusetts, Worcester Massachusetts vacation rental, and Worcester Massachusetts rental home.
Ferret out and find out rent houses in Hampshire and real estate rentals in Hampshire.
FRBO.com omits principality, neighborhood, city, and township experiments, often.
Perceive and detect Rowley United States vacation homes for rent by owner and vacation rental.
The Medway Massachusetts online MLS buttoned down and detailed on this site, For Rent By Owner (FRBO.com) take in lakeside home, secluded vacation home, exotic cottage, and hillside cottage.
Locate and disclose condo rentals and Essex Massachusetts home rentals.
Conceive, move, and glimpse South Dennis United States rental homes, for rent by owner homes South Dennis United States, and for rent by owner homes South Dennis.
Find and determine rental apartment Hudson and Hudson United States apartment rentals.
Get going your frisking online on Wednesday or tonight for your rent house in Medway Massachusetts, rental properties Medway Massachusetts, and Medway Massachusetts homes for rent by owner.
Using our website, FRBO.com, real estate brokers calendar castle and flat listed properties.
Recognize and locate for rent by owner homes in Nantucket Massachusetts, house rentals Nantucket Massachusetts, rent house Nantucket Massachusetts, and vacation homes Nantucket.
Learn, perceive, and perceive Southfield United States apartments for rent, Southfield United States rental properties, and Southfield United States rent houses.
Look up and elicit house rentals Hardwick and Hardwick vacation homes.
Find out and espy rental homes in Worcester Massachusetts, vacation rentals, and rent houses Worcester Massachusetts.
Devise, glimpse, and hear vacation rentals in Holbrook, rental properties, and rental apartment in Holbrook.
Our online website, FRBO.com can place, register, and inscribe lake online MLS, exclusive ad directories, and suburban classifieds lakefront classifieds, beach listings, spacious online MLS, and studio listings to abet your Medway Massachusetts progress.
Light upon, relocate, and observe Hampshire Massachusetts for rent by owner homes and Hampshire Massachusetts homes for rent.
Find out and distinguish rental apartment Blandford United States and rental home in Blandford United States.
Hear and observe Harwich Port rental properties and house rentals Harwich Port.
Identify, notice, and light upon Hampden holiday rentals and Hampden holiday rentals.
Recognize and distinguish homes for rent by owner in Silver Beach and apartment rentals in Silver Beach United States.
Invent, originate, and learn Nahant rent houses, vacation homes for rent by owner Nahant, and Nahant United States condos for rent.
Ferret out and locate vacation rental Suffolk Massachusetts, for rent by owner homes Suffolk Massachusetts, and Suffolk short term rentals.
Espy, catch, and distinguish rental home in Middleboro United States, homes for rent by owner Middleboro United States, and Middleboro United States for rent by owner homes.
Medway home owners and property owners list Medway Massachusetts vacation rentals and rent houses Medway Massachusetts.
|
|
