Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T21:05:14.393' ,`MLSNumber` = '22868169' ,`ListAgentFullName` = 'Donna Harris' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = 'Tiffany Romero' ,`SellingOfficeName` = 'Fathom Realty' ,`Latitude` = '29.987931' ,`Longitude` = '-95.099467' ,`PhotoCount` = '26' ,`PostalCode` = '77532' ,`RoomCount` = '8' ,`ListPrice` = '246000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Big Deer' ,`StreetNumber` = '602' ,`StreetSuffix` = 'Drive' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1804' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this lightly lived in, open floor plan 2 year old home located in the Lake Houston community of Happy Hide A Way. This home features a beautiful kitchen with upgraded appliances, cabinetry and soft close drawers. You will love preparing meals on the kitchen quartz countertops and the large island with butcher block top. All the Delta faucets help bring style to this home and there is no carpet for easy cleaning. The oversized bedrooms offer plenty of room for large furniture. Take advantage of extra storage space in the attic or the in house laundry room which offers plenty of space for an additional freezer or utility sink. The home is situated on over 1/4 of an acre and you will feel at peace amongst all the vegetation which includes lemon trees, loquat trees and a 20+ year old fig tree! Enjoy being minutes from Lake Houston and easy access to major highways. The community offers a clubhouse, park and boat ramp. Plus you will appreciate the low taxes and low HOA fees!' ,`Acres` = '0.2984' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huffman Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 102 HAPPY HIDE A WAY SEC 1 U/R' ,`LotDesciption` = 'Cleared' ,`LotSize` = '13000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '28 - Huffman' ,`SchoolElementary` = 'HUFFMAN ELEMENTARY SCHOOL (HUFFMAN)' ,`SchoolHigh` = 'HARGRAVE HIGH SCHOOL' ,`SchoolMiddle` = 'HUFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Happy Hide A Way Sec 01 U/R' ,`TaxAmount` = '2431' ,`TaxRate` = '2.0083' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419371' WHERE `Matrix_Unique_ID` = '209555865' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T21:08:55.580' ,`MLSNumber` = '61436193' ,`ListAgentFullName` = 'Raquel Sanchez' ,`ListOfficeName` = 'EXIT Lone Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.026736' ,`Longitude` = '-95.488576' ,`PhotoCount` = '29' ,`PostalCode` = '77379' ,`RoomCount` = '0' ,`ListPrice` = '320000.00' ,`Status` = 'Active' ,`StreetName` = 'Brownlee' ,`StreetNumber` = '5222' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2658' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this stunning home in prestigious Terra Nova! Interior of home just recently painted. Upon entry you\'ll be greeted with a large foyer that leads into spacious formal living and dining room. Open kitchen has beautiful countertops, plentiful cabinet space & stainless steel appliances. Primary retreat is on the first floor along with large bathroom including large vanity, and combined shower/tub! The second floor is perfect for multi-generational living with a large gameroom in addition to three additional bedrooms with one full bath. Some updates include a brand new roof, exterior cameras, and recessed lighting outside the home! Highly desirable schools & location. This is a great opportunity that will not last long!' ,`Acres` = '0.2095' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 162 BLK 4 TERRANOVA SEC 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '9125' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'BENFER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'STRACK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Terranova Sec 01' ,`TaxAmount` = '4759' ,`TaxRate` = '2.3266' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419371' WHERE `Matrix_Unique_ID` = '209849190' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T21:55:06.027' ,`MLSNumber` = '89696361' ,`ListAgentFullName` = 'Kimbra Valachovic' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = 'Patricia Brand' ,`SellingOfficeName` = 'Keller Williams Realty - Memorial' ,`Latitude` = '29.622777' ,`Longitude` = '-95.732939' ,`PhotoCount` = '40' ,`PostalCode` = '77406' ,`RoomCount` = '8' ,`ListPrice` = '372000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Pitts' ,`StreetNumber` = '1910' ,`StreetSuffix` = 'Road' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2638' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully UPDATED 1-story home in Pecan Grove! 4 bedrooms, 2.5 bathrooms, formal dining. New flooring throughout, fresh paint, new ceiling fans & light fixtures, and more! Spacious family room with central fireplace, built-ins, and wet bar, perfect for entertaining. Modern kitchen with granite counters, shaker cabinets, central island, and sunny breakfast room. Huge primary retreat boasts tall ceilings & seating area, luxurious shower with 3 heads and custom tile, double sinks, granite counters, built-ins, & walk-in closet. Enjoy the backyard from the expansive patio shaded by mature trees. Conveniently located between Sugar Land & Katy with easy access to 99 & 90, community Country Club with Golf Course, local parks, trails, and sports fields, zoned to FBISD, low taxes & HOA, nearby shopping, dining, & entertainment; The Lifestyle You\'re Looking For!' ,`Acres` = '0.2505' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'PECAN GROVE PLANTATION SEC 3, BLOCK 29, LOT 40' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '10911' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '209' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PECAN GROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRAVIS HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'BOWIE MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pecan Grove Plantation' ,`TaxAmount` = '6222' ,`TaxRate` = '2.2979' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419371' WHERE `Matrix_Unique_ID` = '211348024' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T21:00:54.973' ,`MLSNumber` = '93797838' ,`ListAgentFullName` = 'Jay Schulz' ,`ListOfficeName` = 'Zarco Properties, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.239755' ,`Longitude` = '-95.484597' ,`PhotoCount` = '33' ,`PostalCode` = '77384' ,`RoomCount` = '5' ,`ListPrice` = '646690.00' ,`Status` = 'Active' ,`StreetName` = 'Oak Summit Dr' ,`StreetNumber` = '1010' ,`StreetSuffix` = '' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3054' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW EMERALD HOME located in gated section of Oak Estates at Jacobs Reserve and in the extremely sought-after Woodlands school zone! Located on NEALRY 1/4 ACRE just near Jones State Forest. 4 beds, 3.5 full bath home with MODERN charm featuring GOURMET kitchen w/ sleek quartz countertops featuring ISLAND, built-in Jenn-Aire appliances, double convection oven, & stunning grey cabinetry. Open to dining and family room w/ gas fireplace. French door office off the entryway & HIGH ceilings. HUGE 5-STAR RETREAT w/ sitting area, split vanities, oversized shower, and relaxing soaking tub. On-demand water heater and smart home features. Front porch & covered patio -- perfect for entertaining! JUST A FEW NEW HOME OPPROTUNITIES REMAIN!!!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Emerald Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S748402 - Oak Estates At Jacobs Reserve 02, Block 01, Lot 34' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10129' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1195' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GALATAS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS COLLEGE PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KNOX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Oak Estates at Jacob\'s Reserve' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668419371' WHERE `Matrix_Unique_ID` = '211422962' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T22:22:22.780' ,`MLSNumber` = '72740600' ,`ListAgentFullName` = 'Keith Buchanan' ,`ListOfficeName` = 'KMB Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.283689' ,`Longitude` = '-95.165623' ,`PhotoCount` = '15' ,`PostalCode` = '77328' ,`RoomCount` = '6' ,`ListPrice` = '219900.00' ,`Status` = 'Active' ,`StreetName` = 'Woods' ,`StreetNumber` = '11108' ,`StreetSuffix` = 'Lane' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1400' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderfully updated home in sought after North Woods subdivision. Large, 15k square foot lot. New A/C, new interior paint, new granite countertops, new appliances, new lighting, new bath vanities, new carpet, new tub, and new shower. Don\'t miss out on this great home for an unbeatable price.' ,`Acres` = '0.3444' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'NORTH WOODS 02, LOT 458, ACRES 0.340' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '15000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '24' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'GREENLEAF ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'North Woods 02' ,`TaxAmount` = '2376' ,`TaxRate` = '2.0783' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419371' WHERE `Matrix_Unique_ID` = '211866102' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T21:32:26.247' ,`MLSNumber` = '98554137' ,`ListAgentFullName` = 'Delois Johnson' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.602781' ,`Longitude` = '-95.358060' ,`PhotoCount` = '24' ,`PostalCode` = '77047' ,`RoomCount` = '6' ,`ListPrice` = '265000.00' ,`Status` = 'Active' ,`StreetName` = 'Portman Glen Lane' ,`StreetNumber` = '3907' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1700' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming 2 story, 3 bedrooms, 2.5 bathrooms ready for move-in! Plenty of open space, up and downstairs good for entertaining guess. Light and bright kitchen with L-shape breaskfast bar, French doors leading out side to a large backyard, privated new fence and covered patio for cookout anytime. Upgrades, New A/C and toliets installed. Spacious living room, new vinyl wood floors and new ceiling fan, large windows for more natural lighting, master bedroom well sized and two secondary bedrooms. Flex room up can be converted into a game room for private movie nights. 4 Installed security lights over garage for extra security at night. Great location convenient to Belt 8, 288 Downtown, Med-Center, NRG and Hobby Airport all easily accessible.' ,`Acres` = '' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'HOA First Right of Refusal,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lt 2 Blk 1 Brunswick Lakes Sec 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5270' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '520' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LAW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Brunswick Lakes' ,`TaxAmount` = '4548' ,`TaxRate` = '2.6498' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419372' WHERE `Matrix_Unique_ID` = '212509173' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T21:54:33.033' ,`MLSNumber` = '88988253' ,`ListAgentFullName` = 'Mikael Taylor' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.482796' ,`Longitude` = '-95.461256' ,`PhotoCount` = '31' ,`PostalCode` = '77583' ,`RoomCount` = '3' ,`ListPrice` = '260000.00' ,`Status` = 'Active' ,`StreetName` = 'Aberhill' ,`StreetNumber` = '722' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1560' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come take a look at this well-kept one-story home that has an extended driveway greeted by a beautiful stained-glass door and open entry way with oval recessed ceiling. Open floor plan in kitchen with 42\" cabinets. Range is gas and all energy star rated appliances. Easy access to Fort Bend Tollway and 288. Elementary school is also located inside of community. This home has been kept in immaculate condition and perfect for your clients looking for a great starter home with enough space to grow.' ,`Acres` = '0.1183' ,`Area` = '38' ,`BuilderName` = 'Saratoga' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'GLENDALE LAKES SEC 2, BLOCK 3, LOT 10' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '5154' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Glendale Lakes' ,`TaxAmount` = '5983' ,`TaxRate` = '3.1129' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668419372' WHERE `Matrix_Unique_ID` = '212625282' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T22:17:31.457' ,`MLSNumber` = '83084341' ,`ListAgentFullName` = 'Shelby Matthews' ,`ListOfficeName` = 'Surge Realty' ,`SellingAgentFullName` = 'Yen Truong' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '30.114427' ,`Longitude` = '-95.361459' ,`PhotoCount` = '33' ,`PostalCode` = '77386' ,`RoomCount` = '6' ,`ListPrice` = '685000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Woodland Meadow' ,`StreetNumber` = '4018' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3748' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 4018 Woodland Meadow Drive! This traditional 5 bedroom 3.5 bath home is located in the desired master planned community of Woodson\'s Reserve. This beautiful brick home with luxurious curb appeal is offering an inviting foyer, media room, open concept living and kitchen space. A courtyard leading off of the kitchen breakfast area - a gorgeous custom terrace featuring a built-in grill, mini fridge and sink that leads to a spacious backyard. The primary suite features natural lighting, ensuite bath with separate jacuzzi tub, standing shower, dual sinks and a large walk in closet with custom built-in shelving. Stairs lead you directly into the upstairs gameroom! Woodson\'s Reserve community features a clubhouse, 24 hour fitness center, pools, trails, dog parks and so much more!' ,`Acres` = '0.255' ,`Area` = '40' ,`BuilderName` = 'TAYLOR MORRISON' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S973703 - WOODSON\'S RESERVE 03, BLOCK 4, LOT 6' ,`LotDesciption` = 'Other' ,`LotSize` = '11108' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1335' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'ANN K. SNYDER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodsons Reserve 03' ,`TaxAmount` = '16885' ,`TaxRate` = '3.0987' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419372' WHERE `Matrix_Unique_ID` = '212632349' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T22:22:55.240' ,`MLSNumber` = '47996939' ,`ListAgentFullName` = 'Keith Buchanan' ,`ListOfficeName` = 'KMB Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.619837' ,`Longitude` = '-95.383443' ,`PhotoCount` = '18' ,`PostalCode` = '77047' ,`RoomCount` = '6' ,`ListPrice` = '276900.00' ,`Status` = 'Active' ,`StreetName` = 'Skyview Grove' ,`StreetNumber` = '2615' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2016' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Incredibly updated home in sought after Skyview Park subdivision. New interior paint, new carpet, new a/c condenser, new appliances, new granite countertops, and new porcelain tile. Wood flooring in the living area and nice covered patio. Don\'t miss out on this incredible deal.' ,`Acres` = '0.0964' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 21 BLK 1 SKYVIEW PARK SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LAW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Skyview Park Sec 04' ,`TaxAmount` = '5853' ,`TaxRate` = '2.9307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419372' WHERE `Matrix_Unique_ID` = '212815396' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T21:11:04.510' ,`MLSNumber` = '26422782' ,`ListAgentFullName` = 'Joel Cirilo III' ,`ListOfficeName` = 'Liv Texas' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.667076' ,`Longitude` = '-95.440489' ,`PhotoCount` = '19' ,`PostalCode` = '77025' ,`RoomCount` = '10' ,`ListPrice` = '419000.00' ,`Status` = 'Active' ,`StreetName` = 'Woodshire' ,`StreetNumber` = '4009' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1888' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '4009 Woodshire is a truly exceptional open-design floor plan. This fully renovated home features a character-filled interior which is light, uplifting and merges relaxed living spaces, a good-sized living room and a separate dining room. The charm of the kitchen is sure to impress guests with its stainless-steel appliances, quartz countertops, designer selected tile backsplash, breakfast bar and custom cabinetry with soft close doors and drawers. Brand new roof shingle, electrical panel/ wiring, PEX water lines, and new HVAC system. The primary bedroom is the perfect place to dream and comes complete with a fully-remodeled bathroom and a large closet. Perfectly situated in a safe Willowbend neighborhood. All the conveniences you could possibly need are a short amble away. We love this home. You will too. Call today to schedule a showing!' ,`Acres` = '0.1653' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Willow Meadows Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 104 BLK 3 WESTWOOD SEC 1' ,`LotDesciption` = 'Other' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHEARN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Right Side,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Westwood Sec 01' ,`TaxAmount` = '4605' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1952' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419372' WHERE `Matrix_Unique_ID` = '212925421' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T21:52:50.373' ,`MLSNumber` = '49914187' ,`ListAgentFullName` = 'Erika Jones' ,`ListOfficeName` = 'Berkshire Hathaway HomeServices Premier Properties' ,`SellingAgentFullName` = 'Schakara Eleby' ,`SellingOfficeName` = 'CB&A, Realtors' ,`Latitude` = '30.050727' ,`Longitude` = '-95.476779' ,`PhotoCount` = '50' ,`PostalCode` = '77388' ,`RoomCount` = '11' ,`ListPrice` = '649000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Puget' ,`StreetNumber` = '19410' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4512' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You\'ve arrived behind the gates of Bainbridge Estates on stunning lot w/mature trees! This home,\r\nmeticulously maintained, includes Family room, Formal Dining & Living w/ 2 sided fireplace & wood flooring. Kitchen includes SS appliances & Granite countertops. This home boasts 5 bedrooms w/walk in closets. The owners\' retreat has pool views & door to step out for an evening dip. The spa-like bath has large shower w/rain showerhead, jetted tub, double sinks w/vanity, & 2 walk in closets w/built ins. Sweeping staircase leads you to 4 spacious bedrooms, 2 Jack & Jill baths, and a spacious Media room w/Wet bar, microwave & fridge + long Granite bar ready for the big game & movie night! Two covered patios, Summer kitchen and Firepit are perfect for entertaining. The picturesque Lagoon style pool is amazing at night with LED lighting and beautifully landscaped backyard. Located minutes from Exxon, The Woodlands, and IAH airport. Must see!' ,`Acres` = '0.2989' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 38 BLK 1 BAINBRIDGE ESTATES AMEND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13020' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'HAUDE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN COLLINS HIGH SCHOOL' ,`SchoolMiddle` = 'STRACK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'French,Traditional' ,`Subdivision` = 'Bainbridge Estates' ,`TaxAmount` = '12328' ,`TaxRate` = '2.769' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419373' WHERE `Matrix_Unique_ID` = '213021001' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T21:32:25.233' ,`MLSNumber` = '27299263' ,`ListAgentFullName` = 'Patrick Ma' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.479694' ,`Longitude` = '-95.573654' ,`PhotoCount` = '11' ,`PostalCode` = '77318' ,`RoomCount` = '5' ,`ListPrice` = '130000.00' ,`Status` = 'Active' ,`StreetName` = 'Hill' ,`StreetNumber` = '14378' ,`StreetSuffix` = 'Drive' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1108' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Why rent when you can own your own home. Buy on the lake before prices go up further. There is hardly ever any property for sale in this neighborhood Renovated 3 bedroom 2 baths mobile home on a nice size lot. Steps from Lake Conroe and the marina. Home was just levelled with new paint, flooring, and landscaping. Move in ready! Very quiet lake side community with lots of new build homes and new communities being build nearby. Low taxes. Buyer and Buyer agent must verify all dimension and information.' ,`Acres` = '0.1928' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S622000 - JOHNSON BLUFF, BLOCK 1, LOT 44-B, 45, SERIAL # UNK' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'PARMLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'LYNN LUCAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Johnson Bluff' ,`TaxAmount` = '900' ,`TaxRate` = '1.8448' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419373' WHERE `Matrix_Unique_ID` = '213353978' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T22:27:26.253' ,`MLSNumber` = '79356091' ,`ListAgentFullName` = 'Ruth Ogutu' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.835642' ,`Longitude` = '-95.855209' ,`PhotoCount` = '30' ,`PostalCode` = '77493' ,`RoomCount` = '8' ,`ListPrice` = '460000.00' ,`Status` = 'Active' ,`StreetName` = 'Cambria Green' ,`StreetNumber` = '209' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2553' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home in the heart of the new Sunterra subdivision. This Home offers, 5 Bedrooms with 4 full Baths & 2-Car Garage. The Kitchen features a white Backsplash, 42\" Snowbound Kitchen Cabinets, Granite Countertops with knobs in all the cabinets. Vinyl Plank Flooring in all Main Areas. The Primary Suite offers Double Sinks, Walk-in Shower & Oversized Walk-in Closet with upgraded built in cabinets and shoe rack. The Home is Complete with Full Sod, Sprinkler System & Garage Door Opener!' ,`Acres` = '0.124' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Approved Seniors Project,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S800002 SUNTERRA 2 BLK 1 LOT 32' ,`LotDesciption` = 'Cleared,Cul-De-Sac' ,`LotSize` = '5401' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '2813' ,`TaxRate` = '2.2776' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419373' WHERE `Matrix_Unique_ID` = '213354069' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T21:16:35.890' ,`MLSNumber` = '82053408' ,`ListAgentFullName` = 'Brian Banning' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.592162' ,`Longitude` = '-95.144059' ,`PhotoCount` = '48' ,`PostalCode` = '77062' ,`RoomCount` = '13' ,`ListPrice` = '385500.00' ,`Status` = 'Active' ,`StreetName` = 'Hazel Ridge' ,`StreetNumber` = '14010' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2488' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location, location, location. Enjoy the good life in this gorgeous privately owned home in the highly sought after BAY POINTE subdivision located in the HEART of Clearlake City. This home is open and light and bright. Close to exemplary schools, parks and world class entertainment. Johnson Space Center is close by and just a short hop to Galveston Island. This home has three bedroom and 2.5 baths. The kitchen overlooks the family room. Breakfast area is just off the family room as well. Upstairs gameroom connects both secondary bedrooms. Quiet backyard has a large storage shed for all of your extras.' ,`Acres` = '0.1494' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 26 BLK 1 BAY POINTE SEC 5 AMENDED' ,`LotDesciption` = 'Cleared,Cul-De-Sac' ,`LotSize` = '6507' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '470' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'NORTH POINTE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'CLEARLAKE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bay Pointe Sec 05 Amd' ,`TaxAmount` = '6650' ,`TaxRate` = '2.5769' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419373' WHERE `Matrix_Unique_ID` = '213783431' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T21:14:49.517' ,`MLSNumber` = '10472359' ,`ListAgentFullName` = 'Somer Padilla' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = 'Michael Gee' ,`SellingOfficeName` = 'Real Broker, LLC' ,`Latitude` = '30.130049' ,`Longitude` = '-95.395838' ,`PhotoCount` = '37' ,`PostalCode` = '77386' ,`RoomCount` = '10' ,`ListPrice` = '365000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Lenora Springs' ,`StreetNumber` = '3014' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2507' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 4 bedroom, 1-story located in highly desirable, manned gated comm of Legends Ranch. Fresh/Neutral paint walls & trim, A/C system updated, open floorplan w/high ceilings thru-out creates wide open spaces perfect for everyday living & entertaining. Spacious formal dining, flex space perfect for home office. Gourmet island kitchen boasting tons of granite counters, 42in wood cabinets, gas cooktop, corner pantry & SS appliances. Soaring den w/fireplace, wall of windows overlooking backyard an is open to breakfast area & kitchen. Generous Owners Retreat privately tucked away in this split floorplan features bonus room w/bay windows & backyard views. Primary suite also features private access to 1 of 2 patios. Large primary bath w/dbl vanities & walk-in close. Endless amenities incl pools/splash pad/gym/tennis/basketball & more. Home located mins from I-45, the Hardy, Grand Pkwy, The Woodlands & is zoned to the new Grand Oaks High School. Move-in ready. High & Dry!' ,`Acres` = '0.1639' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S328403 - CANYON LAKES AT LEGEND RANCH 03, BLOCK 1, LOT 20' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '7140' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '990' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BIRNHAM WOODS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Canyon Lakes At Legend Ranch' ,`TaxAmount` = '6896' ,`TaxRate` = '2.5587' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419374' WHERE `Matrix_Unique_ID` = '213801165' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T22:13:37.730' ,`MLSNumber` = '30472249' ,`ListAgentFullName` = 'Nancy Tran' ,`ListOfficeName` = 'World Wide Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.319787' ,`Longitude` = '-94.707203' ,`PhotoCount` = '25' ,`PostalCode` = '75901' ,`RoomCount` = '4' ,`ListPrice` = '189900.00' ,`Status` = 'Active' ,`StreetName` = 'Bruce' ,`StreetNumber` = '208' ,`StreetSuffix` = 'Street' ,`City` = 'Lufkin' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1280' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Perfect location for a faster commute. Fresh interior paint, New Roof, Air Conditioner, Stove and Microwave. Granite counter-top, Newly installed tiles floor. Super clean and move-in ready. House is on quiet Cul-De-Sac open concept brick fireplace in Living room. Backyard with cover patio, very relax environment.' ,`Acres` = '0.1841' ,`Area` = '45' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Angelina County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '6105 SLACK A. C. REVISED BLK 1 LOT 29' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '8019' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '186 - Lufkin' ,`SchoolElementary` = '' ,`SchoolHigh` = 'LUFKIN HIGH SCHOOL' ,`SchoolMiddle` = 'LUFKIN MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Slack A C Rev' ,`TaxAmount` = '2444' ,`TaxRate` = '2.3856' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419374' WHERE `Matrix_Unique_ID` = '213824885' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T21:44:00.240' ,`MLSNumber` = '7256256' ,`ListAgentFullName` = 'Pamela Ward' ,`ListOfficeName` = 'Coldwell Banker The Ron Brown' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.307289' ,`Longitude` = '-97.008908' ,`PhotoCount` = '11' ,`PostalCode` = '77964' ,`RoomCount` = '3' ,`ListPrice` = '390000.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 531' ,`StreetNumber` = '12446' ,`StreetSuffix` = '' ,`City` = 'Hallettsville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1808' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is what Lavaca County is all about - gorgeous gentle rolling pasture with the most magnificent century oaks. The pond in one corner of the property is stocked and ready for you to go fishing! Catch pen and working pens on the back side of the pasture. Such a convenient location! 20 minutes to Hallettsville, Yoakum, and Edna. Less than 2 hours to San Antonio, Houston, Corpus, and Austin makes it the perfect getaway. Sweet Home ISD!! Call your realtor today to schedule your private showing!' ,`Acres` = '28' ,`Area` = '68' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0375 WM RYAN, ACRES 31.1380' ,`LotDesciption` = 'Cleared' ,`LotSize` = '1356371' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '245 - Sweet Home' ,`SchoolElementary` = 'SWEET HOME ELEMENTARY SCHOOL' ,`SchoolHigh` = '' ,`SchoolMiddle` = 'SWEET HOME ELEMENTARY SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Right Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'WM RYAN' ,`TaxAmount` = '2003' ,`TaxRate` = '1.589' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419374' WHERE `Matrix_Unique_ID` = '213976486' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T21:00:45.113' ,`MLSNumber` = '40492549' ,`ListAgentFullName` = 'David James' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = 'Lucia Vazquez' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.842306' ,`Longitude` = '-95.658859' ,`PhotoCount` = '8' ,`PostalCode` = '77084' ,`RoomCount` = '6' ,`ListPrice` = '210000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Cairnlomond' ,`StreetNumber` = '4634' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1160' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Forget that apartment rental and come see this great home that can be yours. Located in award winning Cypress Fairbanks School district, this home has fresh paint and new flooring and new roof with new AC system. It has nice sized closets and a great layout that flows well through the house. Come see your next home.' ,`Acres` = '0.154' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Real Estate Owned,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 16 GLENCAIRN VILLAGE' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '6710' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '325' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'LIEDER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'WATKINS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Glencairn Village' ,`TaxAmount` = '3680' ,`TaxRate` = '2.861' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419374' WHERE `Matrix_Unique_ID` = '214027900' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T22:24:02.290' ,`MLSNumber` = '62460974' ,`ListAgentFullName` = 'Ellen Camp' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.787788' ,`Longitude` = '-95.462751' ,`PhotoCount` = '31' ,`PostalCode` = '77055' ,`RoomCount` = '15' ,`ListPrice` = '1450000.00' ,`Status` = 'Active' ,`StreetName` = 'Ciano' ,`StreetNumber` = '7515' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5719' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fantastic opportunity in gated Ravenna! This luxurious home features 5 BR\'s, 5 1/2 baths w/ 2 PRIMARY BEDROOMS/BATHS & 2 LAUNDRY ROOMS! Stunning spiral staircase w/ custom paneling. French doors & and an abundance of windows allow for plenty of natural light throughout. 3 car rear entry garage, full driveway & fenced grassy area in back. 2 upstairs balconies & 2 courtyards w/ pavers reminiscent of a European village home. Entertaining & everyday living is a breeze in this gourmet kitchen featuring stainless Miele appliances, gas stove, giant custom built-in fridge & sprawling center island. Snuggle up w/ a good book near fireplace in the family room under gorgeous crystal chandelier. Each secondary bedroom is incredibly spacious w/ private en-suite bathroom and walk in closets. Vacation at home in resort style exclusive Ravenna pool and clubhouse. Wide streets for ample guest parking. Walk to Awty International School and zoned to MHS.' ,`Acres` = '0.1684' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 83 BLK 1 RAVENNA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7336' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '4427' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'HOUSMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'English,French,Mediterranean,Spanish,Traditional' ,`Subdivision` = 'Ravenna Sub' ,`TaxAmount` = '39335' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419374' WHERE `Matrix_Unique_ID` = '214036998' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T21:24:09.387' ,`MLSNumber` = '48616879' ,`ListAgentFullName` = 'Brandi Wade' ,`ListOfficeName` = 'Diverse City Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.727074' ,`Longitude` = '-95.368571' ,`PhotoCount` = '21' ,`PostalCode` = '77004' ,`RoomCount` = '4' ,`ListPrice` = '310000.00' ,`Status` = 'Active' ,`StreetName` = 'Eagle' ,`StreetNumber` = '2518' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1518' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spacious 3 bed/2 bath home with original hardwood flooring and loads of character. Home sits on an oversized corner lot in Washington Terrace...steps away from TSU & U of H. Well maintained with minor updates. Comfortably livable in its current condition, but just a bit of polish would make this gem sparkle. Well suited for an owner occupier, landlord, or investor who wants to add their own special touch. All plumbing, HVAC and electrical was redone early 2010. new sewer line 2014. Once you walk in the door, you will be amazed!' ,`Acres` = '0.1205' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 11 BLK 11 WASHINGTON TERRACE' ,`LotDesciption` = 'Corner' ,`LotSize` = '5250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOCKHART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Washington Terrace' ,`TaxAmount` = '3869' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419375' WHERE `Matrix_Unique_ID` = '214049375' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T22:09:54.313' ,`MLSNumber` = '74234302' ,`ListAgentFullName` = 'Diana Sprott' ,`ListOfficeName` = 'Keller Williams Advntge Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.672872' ,`Longitude` = '-95.557453' ,`PhotoCount` = '50' ,`PostalCode` = '77340' ,`RoomCount` = '9' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Summer' ,`StreetNumber` = '3820' ,`StreetSuffix` = 'Lane' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1970' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'IF YOU LIKE THE BEAUTY OF CLEAN LINES, AND LIVING ON THE LAKE SEE THIS! Beautifully updated lakefront home is nestled among the trees and styled to please.' ,`Acres` = '0.4534' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SPRING LAKE - SEC 1, LOT 3.1' ,`LotDesciption` = 'Subdivision Lot,Waterfront' ,`LotSize` = '19750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '360' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'ESTELLA STEWART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Spring Lake' ,`TaxAmount` = '4262' ,`TaxRate` = '1.8868' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419375' WHERE `Matrix_Unique_ID` = '214256181' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214300621','1668419375','214300621','2022-11-13T22:22:46.117','31397778','Claudia Almagro','Texas United Realty','','','29.571118','-95.280617','27','77581','7','259000.00','Active','Isla','2009','Drive','Pearland','2','0','3','7366','Single-Family','This 3 bedroom home is located in the heart of Pearland close to shopping and restaurants. It is on a dead end street. The huge backyard big enough for a pool!! Great for commuters, close to Sam Houston Tollway, Hospitals, Downtown, and more. LOW TAXES, NO HOA, AND ZONED to the exemplary Pearland Independent School District.','','5','','','','','Other Disclosures','','','','Pearland','Central Electric,Central Gas','0','TURNER (PEARLAND) LOT 41','Subdivision Lot','','','','','0','','2','','0','','','','','Composition','42 - Pearland','BARBARA COCKRELL ELEMENTARY SCHOOL','PEARLAND HIGH SCHOOL','PEARLAND JUNIOR HIGH WEST','Supra Keybox','Appraisal District','1','Other Style','Turner Pearland','','','Public Water','1962','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T21:40:50.127' ,`MLSNumber` = '12761800' ,`ListAgentFullName` = 'Courtney Okanlomo' ,`ListOfficeName` = 'Collective Realty Co.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.739339' ,`Longitude` = '-95.405229' ,`PhotoCount` = '45' ,`PostalCode` = '77098' ,`RoomCount` = '12' ,`ListPrice` = '1994500.00' ,`Status` = 'Active' ,`StreetName` = 'Marshall' ,`StreetNumber` = '1815' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '4678' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME TO ANOTHER HAMPTON LANE BUILDERS,100% COMPLETE,ELEVATOR CAPABLE,WINLOW RESIDENCE.LUXE FORMAL DINING RM & PRIVATE STUDY.CUSTOM STAINED HICKORY,HRDWD FLOORING,11FT CEILINGS,DESIGNER COLOR PALETTE,CUSTOM LIGHT FIXTURES & RECESSED LIGHTING ENVELOPE THE HOME.GOURMET KITCHEN W/WOLF & SUB-ZERO APPLIANCES,GRANITE COUNTERTOPS,2-TONE CABINETRY,EXPOSED FAUXWOOD CEILING BEAMS,DOUBLE OVEN,&GREAT RM W/FIREPLACE & BUILT-INS.THE DRY BAR OFFERS SLEEK STORAGE,45-BOTTLE WINE COOLER,& IS STEPS AWAY FROM THE OUTDOOR KITCHEN W/PAVER FLOORING,DEEP SINK & GAS GRILL.2ND FLR GAMEROOM & LOFT AREA.MASSIVE PRIMARY BDRM,COLOSSAL CUSTOM CLOSET W/PACKING ISLAND&MARBLE COUNTERTOPS;SPA-INSPIRED BTH W/DUAL VANITY,RAIN SHOWER & FREE-STANDING TUB.WALK-IN CLOSETS IN ALL BDRMS.LUSH LANDSCAPE W/SPRINKLER SYSTEM,FULL GUTTERS & CEDAR FENCE.4-ZONE HEATING & AIR;2 WATER HEATERS,2 FIREPLACES.PRE-WIRED FOR SURROUND SOUND.MINUTES AWAY FROM RICE U., MUSEUM DISTRICT, MED CTR & DOWNTOWN; SCHEDULE YOUR PRIVATE TOUR TODAY!' ,`Acres` = '0.144' ,`Area` = '16' ,`BuilderName` = 'Hampton Lane Bldrs' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Montrose' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 4 BLK 13 WINLOW PLACE' ,`LotDesciption` = 'Other' ,`LotSize` = '6250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WOODROW WILSON MONTESSORI' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Winlow Place' ,`TaxAmount` = '12791' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668419375' WHERE `Matrix_Unique_ID` = '214323425' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T21:16:53.813' ,`MLSNumber` = '3109498' ,`ListAgentFullName` = 'Lily Loh' ,`ListOfficeName` = 'LV Realty & Services' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.689258' ,`Longitude` = '-95.485368' ,`PhotoCount` = '17' ,`PostalCode` = '77096' ,`RoomCount` = '9' ,`ListPrice` = '359900.00' ,`Status` = 'Active' ,`StreetName` = 'Beechnut' ,`StreetNumber` = '5514' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2321' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Well maintained 1 story home 3bed/2bath zoned to highly acclaimed BELLAIRE HS. Home features with hardwood floor, tiles, and carpets in bedrooms, fresh interior paint, Spacious Living & family rooms, Kitchen with Corian countertops, Ceiling fans in all bedrooms, Large Master Suites with His/Her closets, 2 cars Detached-garage, Large beautiful back yard with trees and deck great for a summer BBQ gathering. Minutes to 59/610 Frwy, medical center, & downtown. Refrig,W&D Included. House did not flood since the owner owned it. This is A MUST SEE!' ,`Acres` = '0.2475' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Meyerland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 25 BLK 9 MAPLEWOOD SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10780' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRAEBURN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'LONG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Maplewood 6 & 7' ,`TaxAmount` = '6433' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1963' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419375' WHERE `Matrix_Unique_ID` = '214338192' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T22:31:44.533' ,`MLSNumber` = '58333347' ,`ListAgentFullName` = 'Ahmad Farooqi' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.822050' ,`Longitude` = '-95.395426' ,`PhotoCount` = '7' ,`PostalCode` = '77018' ,`RoomCount` = '6' ,`ListPrice` = '479000.00' ,`Status` = 'Active' ,`StreetName` = '40th' ,`StreetNumber` = '310A' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1840' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This new construction, modern-farmhouse style, three bedroom, two and a half bath house features impeccable finishes throughout, a soft monochromatic palette and clean lines, and the spacious back yard, which is perfect for relaxing after a long day at work or kids to play. In the chef’s kitchen, there are stainless steel GE high-end appliances, dovetail cabinets, and a wine refrigerator. And upstairs, the ensuite primary bath features a stand-alone tub, spacious enclosed shower, and a walk-in closet. Conveniently located minutes from downtown, the galleria and heights restaurants and shopping. Pictures are renderings and approximate images. This house will be ready for move-in in Nov 2022!' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Ranar Pines' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 9 BLK 5 INDEPENDENCE HEIGHTS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BURRUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Independence Heights' ,`TaxAmount` = '3605' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668419376' WHERE `Matrix_Unique_ID` = '214407706' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214499211','1668419376','214499211','2022-11-13T22:56:38.533','21121256','Emily Pape','Coldwell Banker Realty','','','30.768779','-95.173125','32','77364','0','280000.00','Active','Fishermans Bend','40','Drive','Point Blank','1','0','0','864','Single-Family','WELCOME TO A PIECE OF HEAVEN at Lake Livingston, 3rd-largest lake in Texas. Experience the inner peace of the simple living, beautiful soothing waters & breathtaking views. Away from the nonstop traffic & the hustle and bustle. Come enjoy fishing, boating, skiing, summer swimming or just relaxing in peace. Current owner accomplished nice modifications & upgrades on this quaint Jewel. Starting with its alluring beamboard ceiling & stunning wood beams. The kitchen has been upgraded with recent appliances, intriguing back-splash, beautiful cabinetry, & cozy breakfast island that looks out to your open living area. Custom painting & unique upgraded vinyl laminated flooring thru-out. Great for pets & easy cleaning. Has a Metal roof and a 3-year old septic system. Buyer will need to purchase Lot 3, serves the septic system on Lot 5. HOA fee of $159.00 applies to each lot in the community. Fishing pier & boat launching accessible. Minimal annual fee for pool privileges available.','0.1344','64','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Lake Livingston Area','Central Electric','1','POINT LOOK OUT ESTS #1, BLOCK 12, LOT 5, ACRES .1344','Cleared,Water View','5854','Appraisal District','','159','0','','0','Electric Oven','0','','','Electric Range','','Other','101 - Coldspring-Oakhurst Consolidated','JAMES STREET ELEMENTARY SCHOOL','COLDSPRING-OAKHURST HIGH SCHOOL','LINCOLN JUNIOR HIGH SCHOOL','Appointment Required,No Supra Keybox','Appraisal District','1','Traditional','Point Look Out Estates #1','1613','1.6254','Public Water,Septic Tank','1970','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T22:44:02.517' ,`MLSNumber` = '42343939' ,`ListAgentFullName` = 'Khanh Ha' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.000316' ,`Longitude` = '-95.591105' ,`PhotoCount` = '36' ,`PostalCode` = '77377' ,`RoomCount` = '5' ,`ListPrice` = '395000.00' ,`Status` = 'Active' ,`StreetName` = 'Oxenford' ,`StreetNumber` = '15522' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2969' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to a unique large single story home with 4 bedrooms and 2.5 bathroom. Located in a quite subdivision of Lakewood Forest. Home has large breakfast area, two living rooms featured by a double side fireplace. Wood and tile flooring in main floor and kitchen. Featuring two AC units for better cooling for the home. Hot water heater replaced 2016. New roof in 2016. Close to upscale shopping and dining in The Vintage and Malcolmson Road Hike & Bike Park.' ,`Acres` = '0.1791' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball South/Lakewood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 2 LAKEWOOD FOREST NORTH SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '660' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'LAKEWOOD ELEMENTARY SCHOOL (TOMBALL)' ,`SchoolHigh` = 'TOMBALL MEMORIAL H S' ,`SchoolMiddle` = 'WILLOW WOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Lakewood Forest North Sec 01' ,`TaxAmount` = '6735' ,`TaxRate` = '2.4945' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419376' WHERE `Matrix_Unique_ID` = '214517834' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T21:17:36.917' ,`MLSNumber` = '40920702' ,`ListAgentFullName` = 'Lesley Fontenot' ,`ListOfficeName` = 'JPAR - The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.260909' ,`Longitude` = '-94.844583' ,`PhotoCount` = '47' ,`PostalCode` = '77551' ,`RoomCount` = '6' ,`ListPrice` = '449000.00' ,`Status` = 'Active' ,`StreetName` = 'Beaudelaire' ,`StreetNumber` = '7730' ,`StreetSuffix` = 'Circle' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2400' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 3 bedroom 2.5 bath home is located on a beautiful, quiet street near Moody Gardens and Schlitterbahn and only a few blocks from the Seawall. There is a \"formal living room\" which would make a great play room or bonus room for the kids or a nice home office. There is also a large dining room as well as a breakfast area. The kitchen has beautiful wood cabinets for plenty of storage and pretty granite countertops as well as stainless steel appliances. There is also a large family room with built ins and a beautiful brick wood burning fireplace! The master bathroom has been recently updated and is stunning! There is a 2 car garage with an attached car port around the back of the house. Need a place to relax? Check out this backyard!! A beautifully landscaped oasis is waiting for you! The owners put in new hurricane windows in 2015, new flooring upstairs in 2017, and a new HVAC system and duct work in 2020. This house is a must see! Schedule your tour today!' ,`Acres` = '0.1492' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Near West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 121 HALL & JONES SUR LOT 15 JAKOVICH NO 3 SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Jakovich 3 Sec 3' ,`TaxAmount` = '6063' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419376' WHERE `Matrix_Unique_ID` = '214532198' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T22:15:14.103' ,`MLSNumber` = '9558021' ,`ListAgentFullName` = 'Claudia De La Garza' ,`ListOfficeName` = 'Realty ONE Group, Experience' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.140734' ,`Longitude` = '-95.567245' ,`PhotoCount` = '34' ,`PostalCode` = '77375' ,`RoomCount` = '9' ,`ListPrice` = '955000.00' ,`Status` = 'Active' ,`StreetName` = 'Thunder Valley' ,`StreetNumber` = '120' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4121' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this gorgeous home, in one of the newest subdivisions of Creekside Park. \r\nImpressive entry with high ceilings, open floor plan with lots of light and modern feel. \r\nEnjoy the great gourmet kitchen with granite countertops, soft closing drawers and cabinets, and large island open to the family and dining area. In the first floor you can also find the confortable private primary suite, with a very large bathroom and walk-in closet, a good size study to work comfortably from home, and a guest bedroom with a full bathroom.\r\nEnjoy 2 secondary bedrooms upstairs, along with a good size game room and media room perfect to enjoy family time.\r\nLots of space in the large backyard, perfect to enjoy the nice weather, or to have a nice time in the covered patio.\r\nThis home has everything that you need! Close to parks, trails, shopping, and convenient to top rated schools. Don\'t miss it!' ,`Acres` = '0.2631' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 25 BLK 1 THE WOODLANDS CREEKSIDE PARK WEST SEC 35' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11460' ,`LotSizeSource` = 'Unknown' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'CREEKVIEW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKSIDE PARK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodlands Creekside Park West' ,`TaxAmount` = '17354' ,`TaxRate` = '2.6895' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668419376' WHERE `Matrix_Unique_ID` = '214543784' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T21:53:31.510' ,`MLSNumber` = '60623822' ,`ListAgentFullName` = 'Claudia Cooper' ,`ListOfficeName` = 'City Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.981735' ,`Longitude` = '-95.577510' ,`PhotoCount` = '31' ,`PostalCode` = '77070' ,`RoomCount` = '11' ,`ListPrice` = '320000.00' ,`Status` = 'Active' ,`StreetName` = 'Cypress Forest' ,`StreetNumber` = '14134' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2255' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Expansive home on a quiet street.Whether you\'re looking for a place to live or a property to invest in to expand your real estate portfolio, we\'ve got the ideal place for you! Situated on a sprawling 17,000 sqft lot in a tree-lined street, this house has everything you need - and more! Boasting four bedrooms and two bathrooms, it offers plenty of space to satisfy all your lifestyle needs. The heart of the home is the huge kitchen, with stylish cabinets, sparkling countertops, and modern stainless steel appliances. Its gorgeous, new wooden floors flow seamlessly into the open-plan dining/living area, with stunning high-beamed ceiling and an elegant fireplace. The whole area is filled with light coming in from the sliding doors that lead outside.The bedrooms are spacious and comfortable, with plush carpeting and ceiling fans for year-round comfort. The cherry on top is the expansive backyard. Boasting a lovely shed, it has lots of space for a BBQ and for the kids or pets to run and play.' ,`Acres` = '0.3903' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 2 CYPRESS FOREST SEC 2 U/R' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '17000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MOORE ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Cypress Forest Sec 02 U/R' ,`TaxAmount` = '5032' ,`TaxRate` = '2.1637' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419377' WHERE `Matrix_Unique_ID` = '214616904' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T21:09:03.380' ,`MLSNumber` = '62255906' ,`ListAgentFullName` = 'Hoang Nguyen' ,`ListOfficeName` = 'Avignon Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.853530' ,`Longitude` = '-95.739630' ,`PhotoCount` = '13' ,`PostalCode` = '77449' ,`RoomCount` = '3' ,`ListPrice` = '288000.00' ,`Status` = 'Active' ,`StreetName` = 'Greenwood Summit' ,`StreetNumber` = '5234' ,`StreetSuffix` = 'Trail' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1574' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1373' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 34 BLK 2 JASMINE HEIGHTS SEC 17' ,`LotDesciption` = 'Other' ,`LotSize` = '5980' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Slate' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HEMMENWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Jasmine Hts Sec 17' ,`TaxAmount` = '881' ,`TaxRate` = '2.821' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419377' WHERE `Matrix_Unique_ID` = '214617467' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214626482','1668419377','214626482','2022-11-13T22:31:27.127','73605713','Rafael Perez','Fathom Realty','','','29.681970','-95.931852','50','77441','9','675000.00','Active','Watersmeet','32435','Street','Fulshear','3','0','4','3099','Single-Family','Single Story Home (3000 + square feet) Sits on 1/2 (+/-) Acre Lot on the Golf Course with a Pool. Located in the Gated Community of Weston Lakes with Views of #2 Green. Weston Lakes Golf Course is an 18-hole Championship golf course designed by legendary tour champion Hale Irwin. This spectacular course, 7,064 yards, par 72, offers its members and guests a scenic, yet challenging 18-holes of golf. The Home Features an Open Entry Way, an Open Floor Plan with an Oversized Primary Bedroom and Bathroom. This New Camden Homes Build Property Offers Many Upgrades. The Outdoor Patio and Kitchen Area is Perfect for Entertaining Family and Friends. Also has Hot Tub, Generator Plug and 30 Amp RV plug','0.4542','30','New Camden Homes','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections','1','Fulshear/South Brookshire/Simonton','Central Gas','1','WESTON LAKES SEC 3, BLOCK 2, LOT 89','Cleared,In Golf Course Community,On Golf Course','19785','Appraisal District','','1200','0','','3','Single Oven','1','In Ground','','Gas Range','','Composition','33 - Lamar Consolidated','MORGAN ELEMENTARY SCHOOL','FULSHEAR HIGH SCHOOL','ROBERTS/LEAMAN JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','1','Traditional','Weston Lakes Sec 3','9080','2.1698','Public Sewer,Water District','2006','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214669365','1668419377','214669365','2022-11-13T22:11:23.400','67121979','Connie Nguyen','Houston Met Group','','','29.845941','-95.703627','15','77449','7','289000.00','Active','Broadwind','19114','Lane','Katy','2','1','3','1764','Single-Family','2 Story 3/2/2 single family home with a great floor-plan and a huge back yard. Long extended driveway gives ample spaces for guest parking. This gorgeous home has a spacious floor plan with lots of natural light. All bedrooms located upstairs with and additional lounge or playroom area. Primary bedroom has double sin with shower and tub. Great opportunity to own this gem! This will not last!','0.1136','25','','','','','No Disclosures,Real Estate Owned','','','1','Bear Creek South','Central Electric,Central Gas','1','LT 30 BLK 1 WINDSTONE COLONY SEC 1','Subdivision Lot','4950','Appraisal District','','550','0','','2','','0','','','','','Composition','13 - Cypress-Fairbanks','SHERIDAN ELEMENTARY SCHOOL','CYPRESS LAKES HIGH SCHOOL','THORNTON MIDDLE SCHOOL (CY-FAIR)','Lockbox Front','Appraisal District','2','Traditional','Windstone Colony Sec 1','5152','2.781','Public Sewer,Public Water','2000','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T21:47:08.917' ,`MLSNumber` = '72495894' ,`ListAgentFullName` = 'Cheryl Hadrych' ,`ListOfficeName` = 'Jason Mitchell Real Estate LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.681137' ,`Longitude` = '-96.323376' ,`PhotoCount` = '38' ,`PostalCode` = '77808' ,`RoomCount` = '4' ,`ListPrice` = '480870.00' ,`Status` = 'Active' ,`StreetName` = 'Stonington' ,`StreetNumber` = '3345' ,`StreetSuffix` = 'Way' ,`City` = 'Bryan' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2466' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Step in to this beautiful open concept farm house style home built by Reece Homes in 2020. Home is immaculate and boasts high beamed ceilings, open concept, large 12 foot island, quartz countertops throughout, no carpet...vinyl plank and tile floors throughout. Home is bright and open. front full sized bedroom is used as office space, but can be either. Many upgrades in this home. Come take a look!' ,`Acres` = '0.217' ,`Area` = '61' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GREENBRIER PH 16, BLOCK 6, LOT 20, ACRES .217' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9453' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '365' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '148 - Bryan' ,`SchoolElementary` = 'SAM HOUSTON ELEMENTARY SCHOOL (BRYAN)' ,`SchoolHigh` = 'JAMES EARL RUDDER HIGH SCHOOL' ,`SchoolMiddle` = 'ARTHUR L. DAVILA MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Other Style' ,`Subdivision` = 'Greenbrier Ph 16' ,`TaxAmount` = '8517' ,`TaxRate` = '2.193' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419377' WHERE `Matrix_Unique_ID` = '214694099' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214703072','1668419377','214703072','2022-11-13T22:54:20.337','69041087','Maria Cuevas','Kodu Realty, LLC','','','29.684526','-95.175821','15','77502','4','265000.00','Active','Florence','2603','Avenue','Pasadena','2','0','4','2196','Single-Family','OPEN HOUSE SUNDAY NOVEMBER 20 1-3PM!!! CALL YOUR FAVORITE REALTOR FOR A TOUR, HABLE HOY PARA SU CITA. Great size home with many updated beautiful features and well cared for. ROOF 2019, SOLAR ATTIC FAN, NEW AC INSTALLED 2017, PEX PIPES, RADIANT ATTIC BARRIER, DOUBLE PANE ENERGY EFFICIENT WINDOWS, NEW CABINETS, SEPARATE MINI SPLIT A/C FOR PRIMARY SUITE. Long driveway to detached garage with shelving and ample storage. Nice backyard with storage bldg. Open concept , no HOA. Very clean home, ready for next homeowners. :)','0.1655','6','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','0','Pasadena','Central Gas','0','LT 13 BLK 6 MAURICE R/P','Cleared','7210','Appraisal District','','','0','','1','Gas Oven','0','','','Gas Range','','Composition','41 - Pasadena','MAE SMYTHE ELEMENTARY SCHOOL','SAM RAYBURN HIGH SCHOOL','SOUTHMORE INTERMEDIATE SCHOOL','Accompany,Supra Keybox','Appraisal District','1','Other Style','Maurice R/P','5309','2.6514','Public Sewer,Public Water','1965','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214724213','1668419377','214724213','2022-11-13T21:32:05.407','24356280','Maria Cook','Prime Realty Group','','','28.983959','-95.371571','17','77541','5','159900.00','Active','Zapata','2222','Street','Freeport','2','0','3','1092','Single-Family','Completely remodeled home that is beautiful inside and out. Everything from the Kitchen, Bathrooms, and Bedrooms have been updated. You will need to see this home to appreciate it. Move In ready Home and will not Last Long','0.16','5','','','','','Sellers Disclosure','','','','Freeport','Central Electric','0','VELASCO HEIGHTS (A0049 A CALVIT DIV 14) (B C I C) (FREEPORT)','Subdivision Lot','6970','Appraisal District','','','0','','2','','0','','','','','Composition','7 - Brazosport','VELASCO ELEMENTARY SCHOOL','BRAZOSPORT HIGH SCHOOL','FREEPORT INTERMEDIATE SCHOOL','Lockbox Front','Appraisal District','1','Traditional','Velasco Heights','2218','2.5981','Public Sewer,Public Water','1950','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214724606','1668419377','214724606','2022-11-13T22:15:32.543','24350175','Allison Cornett','JLA Realty','','','30.038138','-94.280466','31','77713','5','495000.00','Active','Bond','14690','Road','Beaumont','3','1','4','3018','Single-Family','Take a look at this stunning 4 bedroom, 3.5 bathroom home on just over an acre of land in the beautiful Diamond D Subdivision. This home will \"WOW\" you with it\'s high ceilings, open floor plan and abundance of natural light. Down stairs features a primary suite, office, and half bath. The spacious kitchen has plenty of counter space and room for an island (there are plugs under the floor). Upstairs you will find a loft, 3 more bedrooms and 2 more bathrooms. We can\'t forget the outdoors! Fresh landscaping, spacious yard with fruit trees and a fenced in salt water pool!','1.102','51','','','','','Sellers Disclosure','1','','','','Central Gas','1','DOGUET\'S DIAMOND D RANCH PHASE 5 LT 43 BLK 4 1.086AC','Cleared','48003','Appraisal District','','300','0','','2','','1','In Ground,Salt Water','','Gas Range','','Other','163 - Hardin-Jefferson','CHINA ELEMENTARY SCHOOL','HARDIN-JEFFERSON HIGH SCHOOL','HENDERSON MIDDLE SCHOOL','Appointment Required,Lockbox Front','Appraisal','1.5','Traditional','Doguets Diamond D Ranch Ph 5','7489','1.9115','Aerobic,Water District','2020','Appraisal District'); --> New record created successfully