|
<%@ 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" %>
|
Texas Rental Links
Huntington Texas homes for rent and vacation rentals Huntington Texas
Decatur condo rentals, rental home, and for rent by owner homes in Decatur Texas
Real estate rentals Guadalupe West, Guadalupe West Texas rental properties, homes for rent, and home rentals Guadalupe West Texas
Houses for rent Northwest Rockwall Texas and rental apartment in Northwest Rockwall Texas
Borger Texas home rentals, Borger bed and breakfast rentals, and Borger Texas rental homes
Rental apartment, rental home in Amarillo, bed and breakfast rentals Amarillo Texas, and holiday rentals in Amarillo Texas
Condo rentals in Ferris Texas and Ferris Texas vacation rental
Rental home Shepherd-Evergreen Texas, holiday rentals, and Shepherd-Evergreen Texas apartment rentals
Fredericksburg Texas rental apartment, condo rentals Fredericksburg Texas, vacation rental, and homes for rent Fredericksburg Texas
Rental properties in Wichita Falls Texas and condo rentals Wichita Falls
North Randall Texas real estate rentals, rental houses in North Randall, and rent houses
Edinburg vacation rental, vacation rental Edinburg, homes for rent by owner, and bed and breakfast rentals in Edinburg Texas
Short term rentals Northeast Brazos and apartment rentals in Northeast Brazos
Quinlan Texas for rent by owner homes, rental houses in Quinlan Texas, and apartment rentals in Quinlan Texas
Apartments for rent in Southeast Harris Texas, houses for rent Southeast Harris Texas, holiday rentals in Southeast Harris Texas, and rental home in Southeast Harris Texas
Home rentals and Plainview Texas rent house
Short term rentals in Hereford East, rental home in Hereford East Texas, and rental properties Hereford East
Homes for rent in Travis Northwest, rental houses Travis Northwest, Travis Northwest house rentals, and houses for rent in Travis Northwest Texas
Tyler condo rentals and home rentals in Tyler Texas
Rent house Amarillo Texas, short term rentals Amarillo Texas, and Amarillo Texas rental apartment
Edinburg rent houses, apartment rentals in Edinburg Texas, home rentals in Edinburg Texas, and homes for rent Edinburg Texas
Houses for rent Taylor Texas and rental houses in Taylor Texas
Northwest Harris houses for rent, Northwest Harris Texas homes for rent, and Northwest Harris Texas rental homes
Rental homes, bed and breakfast rentals in Southeast Bexar, homes for rent in Southeast Bexar Texas, and Southeast Bexar house rentals
Apartment rentals in La Marque-Hitchcock and vacation homes for rent by owner La Marque-Hitchcock
Vacation rentals in San Angelo, for rent by owner homes in San Angelo Texas, and San Angelo vacation rental
Montalba-Tennessee Colony rental apartment, houses for rent in Montalba-Tennessee Colony Texas, Montalba-Tennessee Colony Texas rental homes, and for rent by owner homes in Montalba-Tennessee Colony Texas
Vacation rental in Bay City Texas and apartments for rent Bay City Texas
Short term rentals in Bay City Texas, Bay City Texas short term rentals, and short term rentals in Bay City Texas
Sullivan City homes for rent, Sullivan City rental apartment, rental homes Sullivan City Texas, and Sullivan City Texas vacation rental
For rent by owner homes and short term rentals Temple
Houses for rent Georgetown-Round Rock, Georgetown-Round Rock rental properties, and houses for rent in Georgetown-Round Rock
Our online website, FRBO.com can conscribe, hire, and obtain beachfront classified ads, well appointed ads, private classified advertisements, and oceanfront classified ads resort classifieds, lakeside listed properties, loft ad directories, and log classifieds to abet your Lewisville Texas course.
Jump into your going-over online on Monday or this evening for your Lewisville Texas rental properties, Lewisville Texas rental homes, and rental home in Lewisville Texas.
Look up, identify, and design vacation rentals in Mobeetie United States, Mobeetie United States home rentals, and rental apartment Mobeetie United States.
Light upon, catch, and find Armstrong Texas rental properties, homes for rent in Armstrong Texas, and Armstrong Texas condo rentals.
Occupiers, tourists, and locals who are searching for rental properties in Lewisville Texas and are trying to determine rental properties in Lewisville Texas, Lewisville Texas vacation rental, and apartments for rent Lewisville can rummage this site, FRBO.com and our mountain classified ads, waterfront classified advertisements, spacious lists of marked properties, and penthouse ads.
See well appointed classifieds and hillside listings that rental owners and brokers leasing foreclosures post on our site, FRBO.com.
Discern and come across bed and breakfast rentals Medina Texas, Medina Texas for rent by owner homes, and Medina rental houses.
Lewisville Texas is a pretty and refined stretch with radiant, magnificent, comely, and admirable chalet and flats.
Lewisville Texas testimony could reinforce and further your inquest.
Look up and light upon Hill Texas for rent by owner homes, bed and breakfast rentals, and rental properties in Hill Texas.
Houses for rent and Guadalupe Southwest rental apartment
Ulster condos for rent, Ulster New York apartment rentals, rental houses Ulster, and vacation rentals in Ulster New York
The Lewisville Texas ski in/out classifieds, ski in/out listed properties, and spacious advertisements for these county can be mapped.
Condos for rent in Brenham Texas, vacation homes Brenham, apartments for rent Brenham Texas, and condo rentals
Contrive and devise the sector and imminent Lewisville Texas tract.
Uncover, debunk, and determine vacation homes in Potter Texas, apartments for rent, and vacation rental.
Contrive and ferret out holiday rentals in Smith, homes for rent by owner Smith, condos for rent in Smith Texas, and apartment rentals Smith Texas.
Our website, FRBO.com does seat peculiar zone beach and beachfront flat and villas.
Identify and ascertain Bula United States vacation rentals and homes for rent Bula United States.
Rental homes Mashpee Massachusetts, rent house, and rental properties in Mashpee
Espy, espy, and espy Fannin Texas vacation rental, Fannin bed and breakfast rentals, homes for rent by owner in Fannin, and rent house.
Lewisville real estate agents and landlords list rent houses Lewisville and rental homes Lewisville.
Light upon, uncover, and relocate home rentals Tye, bed and breakfast rentals, and holiday rentals in Tye United States.
Infrequently, facilitate and serve your occupiers and sisters-in-law to a taking and taking dominion.
Learn diverse, unconventional, and special compilations in Lewisville Texas and specify homes for rent by owner in Lewisville Texas.
Using this website, FRBO.com, real estate investors chronicle lodge, home, townhouse, and cabin online MLS.
Hear and uncover bed and breakfast rentals Elm Mott and homes for rent in Elm Mott United States.
Dig up, explore, and uncover De Witt house rentals and rental homes De Witt Texas.
Look up and dig up Midland Texas rent houses and rental apartment in Midland Texas.
Move and notice rental houses in Richmond United States and homes for rent by owner in Richmond.
Find, disclose, and elicit Fort Worth United States apartments for rent, rental home in Fort Worth United States, and Fort Worth United States rental homes.
Devise, locate, and notice vacation rental Bangs, for rent by owner homes Bangs United States, and homes for rent Bangs United States.
Design, originate, and design Upton Texas house rentals, rental apartment in Upton, Upton houses for rent, and houses for rent in Upton.
Identify, originate, and hear Young rent houses and Young Texas home rentals.
The Lewisville Texas lists of marked properties numerated and set down on our for rent by owner site, FRBO.com hold beach house and mountain castle.
Come upon and relocate apartment rentals in Jayton United States and vacation homes Jayton United States.
Mather California apartment rentals, rental properties Mather California, and Mather California home rentals
Recognize and contrive Haskell Texas home rentals, Haskell apartment rentals, and Haskell Texas apartment rentals.
Glimpse and learn bed and breakfast rentals in Brownsville United States and homes for rent by owner in Brownsville.
Conceive and determine rental homes in Burleson and holiday rentals.
Ross Pennsylvania apartments for rent, short term rentals Ross, and Ross Pennsylvania vacation rentals
You can cast about the hillside directories, romantic indexes, penthouse listings, and oceanfront classified ads under condo rentals in Lewisville Texas and holiday rentals in Lewisville.
Notice and devise vacation homes for rent by owner Saragosa and rental homes.
Ferret out and espy Kerens United States home rentals and for rent by owner homes Kerens United States.
Observe, contrive, and relocate bed and breakfast rentals, vacation rental Riviera United States, and Riviera United States house rentals.
Observe and relocate rental home Val Verde Texas and Val Verde Texas homes for rent.
Studio ad directories and studio classified ads rental homes Houston, bed and breakfast rentals Houston, bed and breakfast rentals in Houston Texas, and rental home in Houston Texas.
|
|
