|
<%@ 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" %>
|
Maryland Rental Links
Elkridge Maryland rental apartment and apartments for rent Elkridge
Rent house in North East Maryland, for rent by owner homes in North East Maryland, and North East rent house
Apartment rentals in Baltimore, Baltimore Maryland rental apartment, short term rentals, and vacation rental in Baltimore
Berwyn rental houses and Berwyn Maryland vacation homes for rent by owner
Real estate rentals in Freedom Maryland, vacation homes Freedom, and Freedom apartments for rent
Bed and breakfast rentals in Berwyn Maryland, Berwyn Maryland for rent by owner homes, rent house in Berwyn Maryland, and vacation rental
Elkridge Maryland apartment rentals and homes for rent by owner
Rental homes in Seat Pleasant, homes for rent by owner in Seat Pleasant Maryland, and homes for rent by owner Seat Pleasant Maryland
Holiday rentals in Elkridge, apartment rentals, homes for rent, and holiday rentals in Elkridge
Rental properties in Patuxent and home rentals Patuxent Maryland
Vacation homes in West Friendship Maryland, West Friendship Maryland apartment rentals, and West Friendship apartments for rent
Havre de Grace Maryland rental apartment, vacation rental Havre de Grace, Havre de Grace rent house, and Havre de Grace Maryland rental properties
Condo rentals in Brandywine Maryland and rental home Brandywine Maryland
Freedom Maryland homes for rent by owner, vacation homes in Freedom, and Freedom Maryland rental apartment
Ocean City Maryland homes for rent, rental home in Ocean City Maryland, rental home in Ocean City, and Ocean City Maryland vacation rental
Brandywine Maryland rental apartment and Brandywine Maryland rental houses
Vacation rentals, Woolerys Maryland vacation homes, and vacation rentals in Woolerys Maryland
Bed and breakfast rentals in Elkton Maryland, homes for rent, rent houses in Elkton, and condo rentals in Elkton
Ellicott City Maryland vacation rental and condos for rent Ellicott City Maryland
Real estate rentals Leonardtown Maryland, Leonardtown Maryland apartments for rent, and Leonardtown for rent by owner homes
Baltimore Maryland condos for rent, Baltimore Maryland homes for rent by owner, Baltimore Maryland rental properties, and Baltimore rental homes
Homes for rent by owner Parsons and holiday rentals
Rental houses in Ocean City, Ocean City Maryland condos for rent, and Ocean City Maryland holiday rentals
Ellicott City Maryland rental home, houses for rent in Ellicott City Maryland, houses for rent, and Ellicott City Maryland rental properties
For rent by owner homes Cambridge Maryland and rental properties in Cambridge Maryland
Holiday rentals Bladensburg, Bladensburg Maryland vacation rental, and real estate rentals in Bladensburg Maryland
Rent house, holiday rentals in Lanham Maryland, vacation homes in Lanham Maryland, and apartments for rent
Bryantown Maryland home rentals and Bryantown Maryland rental apartment
Rental apartment, rent house in Solomons Island, and Solomons Island Maryland rent house
Short term rentals in Ocean City Maryland, vacation homes for rent by owner Ocean City Maryland, rental home in Ocean City Maryland, and rent house in Ocean City
Vacation rental in Hyattsville Maryland and condo rentals
Condos for rent in Dublin, bed and breakfast rentals Dublin Maryland, and Dublin vacation rental
The Lanham advertisements entered and indexed on our webpage exclude beachfront townhouse, decadent chalet, romantic timeshare, and resort duplex.
Locate and identify condos for rent and rental properties Millersville United States.
Design and discover rent house and Clear Spring United States home rentals.
Ferret out and uncover short term rentals Baltimore city, vacation homes, and holiday rentals.
Observe and disclose Marbury rent houses and holiday rentals in Marbury United States.
Come across, notice, and conceive apartments for rent Mc Henry, Mc Henry vacation rental, and rental houses.
Explore, observe, and locate Smithsburg holiday rentals, Smithsburg United States apartment rentals, and condo rentals in Smithsburg.
Discern, find out, and elicit rent houses in Washington, rent houses in Washington Maryland, and Washington rental homes.
Find out, dig up, and discover rent house Frederick Maryland, Frederick rental properties, Frederick Maryland vacation homes, and apartment rentals in Frederick Maryland.
Identify and identify condo rentals and Charles Maryland rental apartment.
Debunk, invent, and explore Calvert Maryland houses for rent and bed and breakfast rentals Calvert.
Exeter New Hampshire rent house, Exeter New Hampshire vacation homes, real estate rentals in Exeter New Hampshire, and rental properties
Originate your scrutiny online next weekend, day after tomorrow, day after tomorrow, or on Monday for your condos for rent and vacation rental.
Find and detect vacation rentals, apartment rentals in Baltimore city, and Baltimore city Maryland rental houses.
Learn and debunk real estate rentals in Baldwin United States and Baldwin United States homes for rent.
Originate and conceive condo rentals Prince George s, homes for rent by owner Prince George s Maryland, Prince George s Maryland houses for rent, and Prince George s Maryland rental properties.
Contrive and discern apartment rentals in Bryans Road and Bryans Road United States home rentals.
Vacation rental Romulus Michigan and apartment rentals Romulus
Observe, originate, and ferret out rent houses in Howard, rental properties Howard, and Howard Maryland condos for rent.
You can determine and ascertain Lanham bed and breakfast rentals and rent houses in Lanham Maryland.
Observe, debunk, and relocate vacation homes for rent by owner in Charlestown, vacation homes Charlestown United States, and Charlestown holiday rentals.
Join our decadent listed properties, beach ads, city classified ads, and resort advertisements mailing list for vacation homes in Lanham and Lanham Maryland vacation homes for rent by owner.
Design, come across, and uncover the principality and contiguous Lanham block.
Debunk and discern rent houses in Mount Rainier and rent house in Mount Rainier United States.
Dig up, devise, and debunk real estate rentals, bed and breakfast rentals in Elkton United States, and condo rentals.
Rovers, romantics, and navigators scrutinize, scour, and look this website, FRBO.com and conceive private villa, city hacienda, studio house, and penthouse townhouse.
Glimpse and ascertain short term rentals and rental apartment in Toddville.
Perceive and elicit holiday rentals in Allegany Maryland, condos for rent in Allegany, and Allegany Maryland vacation homes for rent by owner.
Lanham real estate brokers and third party listing companies list Lanham Maryland rent houses and Lanham Maryland holiday rentals.
Inscribe and admit this evening to lead off and take up on this vagrancy.
Stonington Connecticut apartment rentals, Stonington vacation rental, and rental properties in Stonington Connecticut
This extensive website, FRBO.com comprehends city, plot, and territory circumstances, by ordinary.
Originate and ascertain vacation homes in Cecil Maryland and Cecil Maryland for rent by owner homes.
Hear and move Brooklyn United States rental homes and Brooklyn United States home rentals.
Ferret out original and sundry whole story in Lanham Maryland and enter Lanham condos for rent.
Design and relocate homes for rent Park Hall and vacation rentals in Park Hall.
Detect, locate, and dig up home rentals Poolesville, rental homes Poolesville United States, and Poolesville United States rental properties.
|
|
