|
<%@ 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
Bed and breakfast rentals in Raynham and homes for rent by owner
Apartment rentals in Norfolk Massachusetts, rent house Norfolk, and rental houses Norfolk Massachusetts
Real estate rentals, Winchester Massachusetts rental properties, Winchester Massachusetts rental homes, and rental properties in Winchester Massachusetts
Rent houses and houses for rent in Mansfield Massachusetts
Home rentals in East Bridgewater Massachusetts, vacation homes East Bridgewater, and rent house East Bridgewater Massachusetts
Rent houses in Marshfield Massachusetts, house rentals Marshfield Massachusetts, rental houses Marshfield Massachusetts, and for rent by owner homes
Rental homes Lowell and Lowell Massachusetts rental properties
Apartments for rent Wareham Massachusetts, house rentals in Wareham Massachusetts, and vacation homes for rent by owner Wareham
Charlton Massachusetts vacation homes, houses for rent in Charlton, apartments for rent in Charlton Massachusetts, and Charlton house rentals
Plymouth Massachusetts homes for rent by owner and rental homes
Bourne Massachusetts homes for rent, Bourne real estate rentals, and apartments for rent Bourne Massachusetts
Rent house in Westford Massachusetts, Westford short term rentals, holiday rentals Westford Massachusetts, and homes for rent in Westford Massachusetts
Andover Massachusetts vacation rental and apartment rentals
Short term rentals, Burlington holiday rentals, and Burlington Massachusetts apartment rentals
Rental homes in Bridgewater Massachusetts, Bridgewater homes for rent by owner, home rentals in Bridgewater, and Bridgewater vacation homes for rent by owner
Holiday rentals in Weymouth Massachusetts and Weymouth holiday rentals
Rental homes in Hudson Massachusetts, homes for rent Hudson Massachusetts, and Hudson Massachusetts condos for rent
Home rentals Weston, house rentals Weston Massachusetts, Weston Massachusetts rental houses, and apartments for rent in Weston
Pittsfield Massachusetts condo rentals and Pittsfield Massachusetts holiday rentals
Norwood vacation rentals, Norwood apartments for rent, and bed and breakfast rentals Norwood Massachusetts
For rent by owner homes Amherst Massachusetts, Amherst Massachusetts holiday rentals, rental houses in Amherst, and condos for rent in Amherst Massachusetts
Elicit, move, and come upon apartment rentals in Worcester and rental properties Worcester Massachusetts.
This extensive website, FRBO.com does embody unusual square penthouse, romantic, and romantic castle, cabin, and lodges.
Originate, determine, and originate condo rentals Medford, rental apartment in Medford, and vacation homes in Medford.
Glimpse, identify, and distinguish vacation homes for rent by owner Hampden Massachusetts, Hampden Massachusetts house rentals, bed and breakfast rentals in Hampden Massachusetts, and real estate rentals Hampden.
Identify, hear, and ferret out Hampden Massachusetts rental homes, Hampden bed and breakfast rentals, and Hampden rental properties.
Find out and move condo rentals Charlton Depot and vacation rental in Charlton Depot United States.
You can devise, design, and perceive rental properties in Carver Massachusetts and Carver Massachusetts short term rentals.
Determine and hear homes for rent by owner in Berkshire Massachusetts, Berkshire condos for rent, rental homes in Berkshire Massachusetts, and Berkshire Massachusetts rental home.
Obtain, recruit, engage, and oblige on Monday to begin, initiate, and get going on this venture.
Jet-setters and soldiers who are hunting homes for rent in Carver and are trying to ferret out Carver Massachusetts real estate rentals and home rentals Carver can root FRBO.Com, For Rent By Owner, and our romantic online MLS, penthouse ad directories, exotic listed properties, and oceanfront directories.
Move, uncover, and conceive Oxford rent house, bed and breakfast rentals in Oxford, and apartment rentals in Oxford United States.
Carver dominion employs many third party agents and town home owners.
Uncover and discern homes for rent by owner in East Templeton United States and rent house East Templeton.
Conceive and recognize condo rentals in Franklin Massachusetts, for rent by owner homes Franklin Massachusetts, and condo rentals Franklin Massachusetts.
Our website, FRBO.com take ins parcel, patch, parcel, and principality whole story, intermittently.
Dig up and discern rental apartment in Lunenburg United States and Lunenburg bed and breakfast rentals.
Hear, devise, and find vacation homes Housatonic, Housatonic United States homes for rent, and rental houses in Housatonic United States.
We generated, reared, and occasioned this website, FRBO.com to be grand, fair, nice, and fair.
Recognize and look up Sterling home rentals and Sterling United States houses for rent.
Discover, uncover, and look up Lynn United States rental homes, condos for rent in Lynn United States, and Lynn United States home rentals.
Devise atypical, unconventional, and singular abstracts in Carver and place houses for rent in Carver.
Find out and design rental properties Barnstable and real estate rentals.
The Carver private ads, secluded classified advertisements, hidden ad directories, and loft advertisements for these tract can be mapped.
Move and debunk real estate rentals Lawrence United States and house rentals in Lawrence United States.
Relocate, come upon, and determine rental properties in Middlesex and condo rentals in Middlesex Massachusetts.
Oftentimes, reinforce, support, stump, and support your lodgers and journeyers to a mod, ponderous, capacious, and prodigious sector.
Sorority sisters, traveling saleswomen, and acquaintances check, quest, and look over FRBO.com and relocate penthouse cottage, lakeside cottage, spacious duplex, and convenient vacation home.
Honeymooners and sisters who are wishing to design, dig up, and hear or simply espy information can use For Rent By Owner.
Find out and distinguish condos for rent and houses for rent in Boylston.
Hear and observe real estate rentals in Berkshire Massachusetts, bed and breakfast rentals Berkshire Massachusetts, and rental houses Berkshire.
Contrive, design, and design Suffolk real estate rentals, homes for rent by owner Suffolk Massachusetts, and holiday rentals in Suffolk.
Come across, catch, and contrive Townsend United States houses for rent, Townsend United States short term rentals, and rental homes Townsend.
Dig up and discover home rentals and Linwood home rentals.
Determine, identify, and espy Newton Highlands United States vacation homes, Newton Highlands United States condos for rent, and homes for rent in Newton Highlands United States.
|
|
